Warm Up 1,2 assignments. Gives guideline to how the assignment is structured and described. PDF

Preview

Summary

Warm Up 1,2 assignments. Gives guideline to how the assignment is structured and described....

Description

QM323 Class 02 Warmup Delicious Fruit Company (DFC) sells many different fruits. DFC knows the quantity of different types of fruit (in pounds) it sells every day. It is usually able to sell 90% of the fruit it buys. The remainder (unsold) fruit is given to charity. DFC has some fixed costs. Their monthly rent is $2000, the utilities cost $300 and the hourly wage for each of the 5 employees is $10/hour. All the employees work 8 hours a day throughout the month which comprises of 20 days. The other parameters are as follows: Fruit Cost Selling Price Apple $2.00 $3.50 Bananas $1.00 $1.20 Cherries $3.00 $5.00 Dates $4.00 $8.00 Elderberries $5.00 $10.00

Quantity Bought per day 150 200 100 50 50

Please read the whole assignment before you upload your Excel file. 1.

Fill the above information into the template posted on QuestromTools (DeliciousFruitCompany_Spreadsheet_Blank.xls) to calculate DFC’s profit per month.

2.

Watch the video posted in the Lecture 2 folder, titled “Video showing spreadsheet tools useful for Core project”. Add two of the features described in the video to your workbook.

Submit your Excel workbook on the Assignments tab in your section of Questromtools under “WarmUp_Class 02”. Plan to bring your Excel workbook to class on your laptop.

© Boston University. It is a violation of BU’s Academic Conduct Code to post this material anywhere....