H File HOME* Insert\\ Draw Page Layout Formulas Data Review VIEW\\ Help D Tell me what you want to do ^ Share\\\\ ~ Comments A]Z | X V for SQA labor costs ( managers , bookkeepers , person at window ! ! Ei [ . E F EIT {Z| Information for Table 4 {}\\ Other overhead information :" Overhead E.4\\ Rent on = pot in food truck train - Utilities included [ allocate between overhead / } 8 ( A ) 100 permonth {{\\ Insurance / property and / or liability !\\ 345 peryear EEI\\ i'll\\ Information for Table 5 71\\ Selling & Administrative :" 72\\ S& A labor costs ( managers , bookkeepers , person at window ! !! 73\\ SBA 75\\ Rent on = pot in food truck train - Utilities included [allocate between OVERhead / }BLA) 10D\\ permonth 77\\ Cell phone 25 permonth TE\\ Internet access 25 permonth 75\\ Advertising 500 permonth {]\\ Office supplies 150 permonth LE EB E:4\\ Information for Table E {{\\ Every single cost that you've identified on Table = 1 - 5 will be classified here as variable or fixed BE\\ CELL REFERENCE !* BIT {}| Information for Table ] {\\\\ Selling price :" }7\\ Your group's original fair Estimate I per meal ! 2.95 92\\ ASSUMED ROIN 93\\ Your group's calculated Selling price I from Table ! ! 34\\ CELL REFERENCE !* Fir[ Sheet!\\ Sheetz\\ ( +) + 7:8:56AutoSave On. Book1232 - Last Saved 3/27/2019 1:35 PM - abel ramirez File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do Share Comments O D13 X gi B C E F e Attendance is seasonal, as follows (this is attendance per day): 1st quarter (Jan. - March) 2nd quarter (April - June 3rd quarter (July-Sept.) 4th quarter (Oct.-Dec.) Your planned # of meal sales each quarter (document your assumptions and perform your calculations IN the cells): 1,000 2,000 1,500 2,500 1000/20%= 200 *9.99 per meal * 6 days = 11,988 * 13 weeks = $155,844 which is 3 months excluding sundays 155,844 C 24 pack of coke=58 ries=.75 per pound Serving 1/4 pound Information for Table Direct Material Cost: Indirect Labor Cost: X Material Costs identified (research and determine cost) Wings Per meal 2.72 Buffalo Sauce 16.32 1 gallon Direct (traceable per meal): Fries per pound 0.19 Condiments for wings 13 1 gallon vings, fries, drinks Drinks 0.34 Oil for fryers 80 35 pounds Indirect (buy in bulk, not traceable to meal): 7 raw wings makes up a pound ce for wings , oil for fryers, buffalo sauce 10 pounds =24 dollars 34 cents per wing 8 per meal 70 wings=24 dollars Information for Table 2 Direct Labor Indirect Labor 1 Labor Costs identified (research and assign reasonable costs and time) Cooks per hour 10.5 Cashiers per Hour 1.5 42 Direct (time and cost per meal): Fryers Per hour 9.5 |Maintenance Per hour 11 43 |Salaries and wages, benefits, Manager per hour 15 44 45 1 Indirect 46 Maintainance Information for Table Asset information: (keeping it simple... I've provided some information, research and assign reasonable cost) Cost Life Salvage Value Food Truck 25,000.00 10,000.00 Additional cooking equipment (?) 2,000.00 300 Cash register (?) 300 54 Table/desk 100 Chair(s) 50 Storage container(s) for materials 100 57 Office Computer(s) 600 1:45 PM 58 Office Printer(s) 100 3/27/2019 Sheet1 + Select destination and press ENTER or choose Paste 78%
