الســلام علــيكم ورحــمة اللـه وبـركــاتهـ ..
يعــطيــكم الـعافــيه شــباب وبــنـات ..
محــتاج مســاعــدتكــم ضــروري ..
دكــتورنـا فصــل عـلينا ودز لــنا الامتــحان على الايـميـل ولازم باجر الساعـهـ 7 الصـبح ادزه لـهـ .
ومــانـي عــارف بالضبـبط شنــو يبــي ... فـإذا فـي احد يقــدر يســاعدنـي بهالامتــحان ويحــله اكــوون شـاكر لهـ ..
Take Home Exam
Date Due: Sunday 18 March, 9:00 PM
1: Complete the following table using MS-Excel functions to calculate the percentages and totals.
The manager of a vegetable store wants to know what kind of vegetable is most profitable and, on the other hand, which kind is least profitable. The profit of a product is calculated as:
Profit= sale price – cost of product- (shelf rent/refrigerator rent)
Total cost= Cost + shelf cost
ROI= Profit * 100/ Total cost
Table 1: The following table lists the details for all types of vegetables sold:
Vegetable per 1000 KG
Cost
Shelf/ Refrigerator rent
Sale Price
Profit
ROI, Return on Investment
Tomatoes
100
60
330
Potatoes
110
20
360
Cucumber
65
35
290
Lettuce
180
220
400
Parsley
100
350
500
Carrots
100
120
300
Total
After you complete all calculations for the table, complete the two other tables below:
Table 2: Table of Vegetables showing the highest profitable kind of vegetables, then the rest to the lowest profit.
Vegetable
Profit for 1000 KG
Table 2: This table lists the vegetables according to their ROI data.
Vegetable
ROI
2: Draw a Pi-Chart showing profits for store from selling the 6 types of vegetables.
3: Write a report in MS-Word giving a brief description (from your creation) of the vegetable store in the first paragraph. The second paragraph should talk about the 6 kinds of vegetables you sell, the most profitable ones and the least .
The report should answer the following questions.
a. What are the most three profitable kinds?
b. What are the least profitable 2 kinds?
c. If you want to expand in a particular type of vegetable, which kind will you invest in?
d. If you want to stop dealing with a particular type of vegetable, which kind will you stop selling?
The report should include all tables and Pi-chart.
3: make a 7-slide presentation of this project including at least 2 objects (table/chart) in your presentation.
4: save your work and email all your work to me