accounting with excel 495037

Twelve months ago, David opened a coffee shop, The the first year of operations. Fringe benefits for David, Daily Grind, in Mercy Hospital’s former gift shop. including health insurance and payroll taxes, accounted David was confident that he had the knowledge ro for an additional -“k. $10,000 of cosrs for th. company. a success of this new business. He produced a quality Part-time employees work an average of 24 hours product that people needed, had priced the product each week and are paid payroll per $9 hour. taxes and to be very competitive, and had a gteat location in a other costs average about pu, $1.00 Lorr for part_ high-traffic area of the hospital. time employees. As shown in the following table, part_ time employees worked from 656 ho.r., to 727 hours each month: Material Gosts Part-time Employee t3-n. Month Labor Hours o”il, *i;; ;;;;;; ;;”;;-l A January coffee beans costing l22hours $B per pound. Each pound I of coffee beans produces February 256 ounces of coffee. boff”” I 656 hours is soid in three sizes: g j a small cup holding March ourl…, 727 hours medium ” cup holding 12 ounces, and a large .,rp hoid_ l April 705 hours ing 16 ounces. I -/27 May hours The cups needed to serve the coffee cost $.0-5 for I June the small 705 hours cup, $.06 for the g.07 j medium cup, and for the large July cup. Lids cost 727 hours per $.03 cup-and are the i same regardless of cup size. August Sleeves cost an additional 727 I hours per $.04 cup. On average, sugar and cream cost September $.02 oer I 705 hours cup for small cups, $.03 for medium j cups, and fo. $.0+ October , 721 hours large j cups. November 705 hours I _l December lll nours lahor Gosts ” -t j he Daily Grind is open 12 hours each d,ay,7 days : 0uerhead a week (365 days per Gosts year), and is staffed with , !,’i.il-“- three i1:l employees during the morning shift…