Question

In: Accounting

Madison Park Co-op, a whole foods grocery and gift shop, has provided the following data to...

Madison Park Co-op, a whole foods grocery and gift shop, has provided the following data to be used in its service department cost allocations: Service Departments Operating Departments Administration Janitorial Groceries Gifts Departmental costs before allocations $210,000 $60,000 $3,900,000 $350,000 Employee-hours 490 300 2,750 150 Space occupied—square feet 800 1,300 9,400 600 Required: Using the step-down method, allocate the costs of the service departments to the two operating departments. Allocate Administration first on the basis of employee-hours and then Janitorial on the basis of space occupied. (Please enter allocations from a department as negative and allocations to a department as positive. The line should add across to zero. Do not round intermediate calculations. Round your answers to the nearest whole dollar amount.)

Solutions

Expert Solution

In the step down method the costs are also allocated to other service departments. The total cost of the other service department increases by the allocation and then this increased is allocated.

We start with administration cost. This will be allocated to Janitorial, Groceries and Gifts.It is allocated based on employee-hours.

Total employee-hours are 160+3,100+740 = 4,000

Cost allocated to Janitorial = 150,000 X 160/4,000 = 6,000

Cost allocated to Groceries = 150,000 X 3,100/4,000 = 115,250

Cost allocated to Gifts = 150,000 X 740/4,000 = 27,750

Next we allocate Janitorial costs. Once the cost of any service department are allocated, then no cost is again allocated to that department. The cost is allocated to other remainingservice departments. In this case there are no remaining service departments and so the Janitorial cost would be allocated to only Groceries and Gifts.

Total cost is now 40,000+6,000 (allocated) = 46,000 and is allocated based on space occupied.

Total space for Groceries and gifts is 4,000+1,000=5,000

Cost allocated to Groceries = 46,000 X 4,000/5,000 = 36,800


Related Solutions

Have a look at Whole Foods Market, the upscale grocery retailer. Go and explore the company...
Have a look at Whole Foods Market, the upscale grocery retailer. Go and explore the company and products at (official webiste of whole foods market). Take some time to learn about the types of products offered and the product information provided. The website is full of information about product lines, quality standards, safety standards, coupons, and more. Choose items of interest to you. a) What unique pricing strategy has Whole Foods adopted in the food marketplace? b) Relative to competitors,...
Whole Foods and Amazon Over the past decade, Whole Foods Market, Inc., has become an increasingly...
Whole Foods and Amazon Over the past decade, Whole Foods Market, Inc., has become an increasingly familiar part of the urban landscape. As of November 5, 2014, the company had 401 stores in the United States, Canada, and the United Kingdom. Using financial websites such as finance.yahoo.com and money.msn.com, you can access a wealth of financial information for companies such as Whole Foods. By entering the company’s ticker symbol, WFM, you will be able to access a great deal of...
Madison Company, which has only one product, has provided the following data concerning its most recent...
Madison Company, which has only one product, has provided the following data concerning its most recent month of operations: Selling price $166 Units in beginning inventory 600 Units produced 13,200 Units sold 13,350 Variable costs per unit: Direct materials $51 Direct labour $56 Variable manufacturing overhead $5 Variable selling and administrative $13 Fixed costs: Fixed manufacturing overhead $92,400 Fixed selling and administrative $253,650 The company produces the same number of units every month, although the sales in units vary from...
Via Gelato is a popular neighborhood gelato shop. The company has provided the following data concerning...
Via Gelato is a popular neighborhood gelato shop. The company has provided the following data concerning its operations: Fixed Element per Month Variable Element per Liter Actual Total for June Revenue $ 16.00 $ 90,540 Raw materials $ 5.05 $ 31,630 Wages $ 6,000 $ 1.80 $ 16,900 Utilities $ 2,030 $ 0.60 $ 6,000 Rent $ 3,000 $ 3,000 Insurance $ 1,750 $ 1,750 Miscellaneous $ 690 $ 0.75 $ 5,200 While gelato is sold by the cone or...
Which of the following terms is used to indicate that a donor provided a gift with...
Which of the following terms is used to indicate that a donor provided a gift with explicit instructions that the gift is to be used for a specific purpose by the not-for-profit but the entire amount may be spent right away? A. Net assets with donor restrictions. B. Permanently restricted net assets. C. Endowment assets. D. Net assets without donor restrictions.
The following are misstatements that have occurred in Fresh Foods Grocery​ Store, a retail and wholesale...
The following are misstatements that have occurred in Fresh Foods Grocery​ Store, a retail and wholesale grocery​ company: 1. On the last day of the​ year, a truckload of beef was set aside for shipment but was not shipped. Because it was still on hand the inventory was counted. The shipping document was dated the last day of the​ year, so it was also included as a​ current ­year sale. 2. The incorrect price was used on sales invoices for...
The following are errors or fraud and other irregularities that have occurred in Fresh Foods Grocery...
The following are errors or fraud and other irregularities that have occurred in Fresh Foods Grocery Store Ltd., a wholesale and retail grocery company. The incorrect price was used on sales invoices for billing shipments to customers because the incorrect price was entered into a computer file. A vendor’s invoice was paid twice for the same shipment. The second payment arose because the vendor sent a duplicate copy of the original two weeks after the payment was due. Employees in...
Q1. Quickmeal Description of data Quickmeal is a local grocery shop that carries a limited variety...
Q1. Quickmeal Description of data Quickmeal is a local grocery shop that carries a limited variety of meat products, vegetable and fruits, dairy products, and beverages. The owner of Quickmeal, let’s call him John, wants to expand his business. John wants to understand the purchasing behaviour of his customers, so he can predict future demands. He recorded daily sales of products in June. The dataset is called “Quickmeal”, which is available in different formats. It shows the daily sales in...
Provided is the following data for Marina Bay, a boat repair shop. Repairs Material Loading Charges...
Provided is the following data for Marina Bay, a boat repair shop. Repairs Material Loading Charges Mechanics’ wages and benefits $103,500 Parts manager’s salary and benefits $11,500 Office employee’s salary and benefits 20,700 2,300 Other overhead (supplies, depreciation, property taxes, advertising, utilities) 26,800 14,400 Total budgeted costs $151,000 $28,200 Employees worked 5,000 hours for repair work. Marina Bay desires a profit margin of $8 per hour. The total invoice cost of parts and materials used was $120,000. Marina Bay desires...
The payroll records of Barnes Co. provided the following data for the current weekly pay period...
The payroll records of Barnes Co. provided the following data for the current weekly pay period ended March 12. Employees Earnings to End of Previous Week Gross Pay Federal Income Taxes Medical Insurance Deduction Union Dues United Way R.Short $5,800 $800 $120 $35 $10 $10 L. Skyler 6,850 1,000 180 35 10 15 C. Richard 12,900 1,440 404 35 10 10 The Earnings to End of Previous Week are gross earnings for the year prior to the current weekly pay...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT