Family Supermarkets has decided to increase the size of its Lansing store. It wants information about the profitability of its individual product lines: meats, fresh produce, and packaged food. The following data is for the year 2017 for each product line: Meats Fresh Produce Packaged Foods Revenue $815,000 $850,000 $470,000 Cost of goods sold $615,000 $610,000 $350,000 purchase orders 274 312 142 hours of stocking shelves 211 2,132 1,032 items sold 325,000 455,000 120,000 The Company also provides the following information for 2017 for its three support activities: Support Activity Budgeted Cost Cost Driver Ordering $127,000 purchase orders Shelf stocking $72,000 hours of stocking shelves Customer support $154,000 Required: items sold Family Supermarkets currently uses a single-driver system to allocate period costs to its product lines. The single driver that is used is the Cost of Goods Sold for each product line. Using this system, compute the allocation to Packaged Foods.

Family Supermarkets has decided to increase the size of its Lansing store. It wants information about the profitability of its individual product lines: meats, fresh produce, and packaged food. The following data is for the year 2017 for each product line: Meats Fresh Produce Packaged Foods Revenue $815,000 $850,000 $470,000 Cost of goods sold $615,000 $610,000 $350,000 purchase orders 274 312 142 hours of stocking shelves 211 2,132 1,032 items sold 325,000 455,000 120,000 The Company also provides the following information for 2017 for its three support activities: Support Activity Budgeted Cost Cost Driver Ordering $127,000 purchase orders Shelf stocking $72,000 hours of stocking shelves Customer support $154,000 Required: items sold Family Supermarkets currently uses a single-driver system to allocate period costs to its product lines. The single driver that is used is the Cost of Goods Sold for each product line. Using this system, compute the allocation to Packaged Foods.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter20: Inventory Management: Economic Order Quantity, Jit, And The Theory Of Constraints

Section: Chapter Questions

Problem 7E: Ottis, Inc., uses 640,000 plastic housing units each year in its production of paper shredders. The...

See similar textbooks

Similar questions

Please solve all the questions
I need help and i need the excel functions (answers by using excel)
Fisk Corporation is trying to improve its inventory control system and has installed an online computer at its retail stores. Fisk anticipates sales of 60,500 units per year, an ordering cost of $12 per order, and carrying costs of $1.20 per unit.a. What is the economic ordering quantity?___________Units b. How many orders will be placed during the year? __________Orders c. What will the average inventory be? ____________Units d. What is the total cost of ordering and carrying inventory? $____________
Please answer questions 1.1.2 and 1.2 only
I need a detailed explanation of how you got the answer NOT just the answer please. Please see attached image for question. Thank you.
Fan Base (FB) operates a megastore featuring sports merchandise. It uses an E0Q decision model to make inventory decisions. It is now considering inventory decisions for its Los Angeles Galaxy soccer jerseys product line. This is a highly popular item. Data for 2011 are as follows: Expected annual demand for Galaxy jerseys Ordering cost per purchase order Carrying cost per year Each jersey costs FB $40 and sells for $80. The $7 carrying cost per jersey per year comprises the required return on investment of $4.80 (12% x $40 purchase price) plus $2.20 in relevant insurance, handling, and theft-related costs. The purchasing lead time is 7 days. FB is open 365 days a year. a) Calculate the E0Q. Required 10,000 $200 $7 per jersey b) Calculate the number of orders that will be placed each year. c) Calculate the reorder point.
4. Genesis Company is a wholesaler. It purchases 60,000 units of Product X per month for sale to retailers. The cost of placing an order is P100. The cost of holding one unit of inventory for one year is P4. Note: Kindly input your answer with comma. Example: 10,000 Required: a. Compute the economic order quantity. b. How many orders would be placed under the EOQ policy? c. Compute the annual ordering cost for the EOQ. d. Compute the annual carrying cost for the EOQ. e. Compute the total inventory-related cost at the EOQ.
QUESTION 1 The following information regarding the purchases and issues to production or component J for a project of Kia Limited during April 2020 is available: Purchases April Units Total invoice price 01 13 000 R91 000 10 15 000 R120 000 20 14 000 R126 000 Issues to production April Units 05 8 000 15 9 000 25 13 000 Refer to the information provided above and answer the following questions: 1.1.1 Use the first-in-first-out (FIFO) method to complete the following table for the transactions provided below: Purchases Issues Balance Date Quantity Price Amount Quantity Price Amount Quantity Price Amount 1.1.2 Use the weighted average cost method to complete the above table for the transactions up to 15 April 2020 only. Where applicable, round off the weighted average cost per unit to the nearest cent and other amounts to the nearest Rand.
Gigasales Department Store Income Statement For the Year Ended December 31, 2022 Net sales $700,000 Cost of goods sold 560,000 Gross profit 140,000 Operating expenses Selling expenses $100,000 Administrative expenses 20,000 120,000 Net income $ 20,000 Karen believes the problem lies in the relatively low gross profit rate of 20%. Reece believes the problem is that operating expenses are too high. Karen thinks the gross profit rate can be improved by making two…
Dream Corporation is trying to improve its inventory control system and has installed an online computer at its retail stores. Howe anticipates sales of 126,000 units per year, an ordering cost of P4 per order, and carrying costs of P1.008 per unit. The following year, the company. learns it can reduce ordering costs to P1 per order but that carrying costs will stay the same at P1.008 per unit. What is the total cost of inventory to be expected?
Want Answers
Please help me