MGSC290_Solver_Practice

MGSC290_Solver_Practice - $2.25 6 6 3 2 Cakes Sold Vanilla...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
cf71b600e638ccbd3b1806d18a8dd32e0b1402cc.xlsx Page 1 of 1 Solver Wedding Cakes Are Us - Income Analysis (Solver) Ingredients Inventory * Variable Expenses Standard Deluxe Cajun Cheesecake Description Available Ordered Remaining Cost Standard Deluxe Cajun Cheesecake Cakes Ordered 0 0 0 0 Self-Rising Flour (Cup) 3000 $2.15 8 8 0 0 Cost of Ingredients * All-Purpose Flour (Cup) 4000 $1.25 0 0 18 0 Cost of Preparation $5.00 $5.00 $8.00 $10.00 Baking Soda (Teaspoon) 2600 $0.55 0 0 12 0 Total Cake Cost ** White Sugar (Pound) 8475 $1.25 8 8 12 10 Total Variable Expenses * Brown Sugar (Pound) 955 $2.50 0 2 0 0 Large Eggs (Dozen) 1245 $2.50 3 3 1 3 Revenue Standard Deluxe Cajun Cheesecake Butter (Pound) 3210
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $2.25 6 6 3 2 Cakes Sold Vanilla Extract (Ounce) 2955 $0.65 6 6 6 Price per Cake $90.00 $100.00 $130.00 $150.00 Cream Cheese (Pound) 2000 $3.75 14 Total Revenue * Flavor Package #1 782 $6.15 1 2 1 Flavor Package #2 210 $10.30 1 Summary Flavor Package #3 145 $25.10 1 Total Revenue Total Variable Expenses Total Fixed Expenses $500.00 * indicates that SUMPRODUCT can be used to complete this formula. Net Income ** indicates that SUM can be used to complete this formula....
View Full Document

This note was uploaded on 06/25/2011 for the course MGSC 290 taught by Professor Johnston during the Fall '09 term at South Carolina.

Ask a homework question - tutors are online