{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

L3 Coffee Shop Spreadsheet - Coffee Shop As Is Monthly...

This preview shows pages 1–2. Sign up to view the full content.

As Is: Monthly Profit/(Loss) Assumptions Fixed Costs (FC) Number of days per month 30 Monthly Building Costs Servings per hour per empl 25 \$17,500.00 Utilities \$1,250.00 Sales Prices Total \$18,750.00 Tea \$0.75 Daily Equip Costs Coffee \$2.00 Tea \$7.14 Cappuccino \$3.00 Coffee \$10.71 Cappuccino \$21.43 Ingredient Costs per Unit Total \$39.29 Tea \$0.15 Monthly Equip Cost \$1,178.57 Coffee \$0.20 Cappuccino \$0.30 Total Monthly Fixed Costs \$19,928.57 Supply Costs per Unit Paper Products \$0.05 Variable Costs (VC) Condiments \$0.02 Daily Supply Costs \$37.95 Employee Costs Condiments \$15.18 Wage \$7.00 Ingredients \$637.10 Overhead \$3.00 Daily Employee Costs Total Daily VC \$690.23 Weekly Equipment Costs Tea \$50.00 Total Monthly Variable Costs \$20,706.90 Coffee \$75.00 Cappuccino \$150.00 Summary Demand for all days is equal Total Monthly Sales \$46,665.00 Employees do not take breaks Total Monthly Costs FC + VC \$40,635.47 All beverages require equal prep time Employees are willing to work for one hour Monthly Profit/(Loss) \$6,029.53 by Joe Bobcat Lease per month Paper Products Checkpoint \$6,029.53 1. Begin by naming all of the numeric cells in Assumptions area. Use CamelBack notation. Then follow the rest of the steps in order. Note that step 5 is up here but step 6 is at the end. 5. Calcula totals usin data from previous s You shoul name all c in the Fixe Cost, Vari Cost, and Summary sections. Checkpoin

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 6

L3 Coffee Shop Spreadsheet - Coffee Shop As Is Monthly...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online