L3 Coffee Shop Spreadsheet

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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

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 Right Arrow Icon
Ask a homework question - tutors are online