Concept explainers
Home Depot Pleasanton Gardening Center needs to determine the ordering policy in the ERP system for a new retaining wall blocks. The demand
COST ITEM |
COST ($) |
COST ITEM |
COST ($) |
Taxes for the warehouse |
2,000 |
Warehouse supplies |
280 |
Receiving and incoming inspection |
1,500 |
Research and development |
2,750 |
New product development |
2,500 |
Purchasing salaries & wages |
30,000 |
Acct. Dept. costs to pay invoices |
500 |
Warehouse salaries & wages |
12,800 |
Inventory insurance |
600 |
Pilferage of inventory |
800 |
Product advertising |
800 |
Purchase order supplies |
500 |
Spoilage |
750 |
Inventory obsolescence |
300 |
Sending purchasing orders |
800 |
Purchasing Dept. |
1,000 |
Accounting department also told you that these data were compiled for handling 100,000 variety of inventory units that were carried or held during the year. You have also aware that 2000 orders were placed last year. Your job as a supervisor of supply analytics is to determine the economic order quantity (EOQ), ordering frequency per year, total ordering cost, and total inventory carrying cost, for this new product.
Trending nowThis is a popular solution!
Step by stepSolved in 4 steps with 3 images
- Resource Supply and Usage, Special Order, Relevancy Elliott, Inc., has four salaried clerks to process purchase orders. Each clerk is paid a salary of $22,900 and is capable of processing as many as 6,950 purchase orders per year. Each clerk uses a PC and laser printer in processing orders. Time available on each PC system is sufficient to process 6,950 orders per year. The cost of each PC system is $1,300 per year. In addition to the salaries, Elliott spends $30,024 for forms, postage, and other supplies (assuming 27,800 purchase orders are processed). During the year, 27,200 orders were processed Required: 1. Which of the resources associated with purchasing can be classified as flexible resources? Which of the resources associated with purchasing can be classified as committed resources? 2. Compute the total activity availability, and break this into activity usage and unused activity. Activity availability: purchase orders Activity usage: purchase orders Unused activity: purchase…arrow_forwardOttis, Inc., uses 640,000 plastic housing units each year in its production of paper shredders. The cost of placing an order is 30. The cost of holding one unit of inventory for one year is 15.00. Currently, Ottis places 160 orders of 4,000 plastic housing units per year. Required: 1. Compute the economic order quantity. 2. Compute the ordering, carrying, and total costs for the EOQ. 3. How much money does using the EOQ policy save the company over the policy of purchasing 4,000 plastic housing units per order?arrow_forwardCorazon Manufacturing Company has a purchasing department staffed by five purchasing agents. Each agent is paid 28,000 per year and is able to process 4,000 purchase orders. Last year, 17,800 purchase orders were processed by the five agents. Required: 1. Calculate the activity rate per purchase order. 2. Calculate, in terms of purchase orders, the: a. total activity availability b. unused capacity 3. Calculate the dollar cost of: a. total activity availability b. unused capacity 4. Express total activity availability in terms of activity capacity used and unused capacity. 5. What if one of the purchasing agents agreed to work half time for 14,000? How many purchase orders could be processed by four and a half purchasing agents? What would unused capacity be in purchase orders?arrow_forward
- Haysbert Company provides management services for apartments and rental units. In general, Haysbert packages its services into two groups: basic and complete. The basic package includes advertising vacant units, showing potential renters through them, and collecting monthly rent and remitting it to the owner. The complete package adds maintenance of units and bookkeeping to the basic package. Packages are priced on a per-rental unit basis. Actual results from last year are as follows: Haysbert had budgeted the following amounts: Required: 1. Calculate the contribution margin variance. 2. Calculate the contribution margin volume variance. 3. Calculate the sales mix variance.arrow_forwardNozama.com Inc. sells consumer electronics over the Internet. For the next period, the budgeted cost of the sales order processing activity is 250,000 and 50,000 sales orders are estimated to be processed. a. Determine the activity rate of the sales order processing activity. b. Determine the amount of sales order processing cost associated with 30,000 sales orders.arrow_forwardPlay-Disc makes Frisbee-type plastic discs. Each 12-inch diameter plastic disc has the following manufacturing costs: For the coming year, Play-Disc expects to make 300,000 plastic discs, and to sell 285,000 of them. Budgeted beginning inventory in units is 16,000 with unit cost of 4.75. (There are no beginning or ending inventories of work in process.) Required: 1. Prepare an ending finished goods inventory budget for Play-Disc for the coming year. 2. What if sales increased to 290,000 discs? How would that affect the ending finished goods inventory budget? Calculate the value of budgeted ending finished goods inventory.arrow_forward
- The expected costs for the Maintenance Department of Stazler, Inc., for the coming year include: Fixed costs (salaries, tools): 64,900 per year Variable costs (supplies): 1.35 per maintenance hour Estimated usage by: Actual usage by: Required: 1. Calculate a single charging rate for the Maintenance Department. 2. Use this rate to assign the costs of the Maintenance Department to the user departments based on actual usage. Calculate the total amount charged for maintenance for the year. 3. What if the Assembly Department used 4,000 maintenance hours in the year? How much would have been charged out to the three departments?arrow_forwardA company uses charging rates to allocate service department costs to the using departments. The accountant compiled the following information on one of the service departments: If Department K plans to use 1,350 hours of the service departments service in the coming year, how much of the service departments cost is allocated to Department K? a. 3,375 b. 27,300 c. 26,325 d. 23,950arrow_forwardResource Supply and Usage, Special Order, Relevancy Elliott, Inc., has four salaried clerks to process purchase orders. Each clerk is paid a salary of $22,100 and is capable of processing as many as 6,150 purchase orders per year. Each clerk uses a PC and laser printer in processing orders. Time available on each PC system is sufficient to process 6,150 orders per year. The cost of each PC system is $1,300 per year. In addition to the salaries, Elliott spends $26,568 for forms, postage, and other supplies (assuming 24,600 purchase orders are processed). During the year, 24,000 orders were processed. Required: 1. Which of the resources associated with purchasing can be classified as flexible resources? Forms, Postage and Supplies Which of the resources associated with purchasing can be classified as committed resources? PC system and clerks 2. Compute the total activity availability, and break this into activity usage and unused activity. Activity availability: purchase orders…arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub