Question 5 A company's forecast of demand in shown in the following table. Regular production costs $138 per unit with a monthly capacity of 47 units. Subcontracting costs $276 per unit and has unlimited capacity. It costs $13.0 per unit per month to hold inventory and $33 per unit per month to run backlogs. Period 3 Forecast 68 79 86 What is the total cost of a LEVEL aggregate plan?

Question 5 A company's forecast of demand in shown in the following table. Regular production costs $138 per unit with a monthly capacity of 47 units. Subcontracting costs $276 per unit and has unlimited capacity. It costs $13.0 per unit per month to hold inventory and $33 per unit per month to run backlogs. Period 3 Forecast 68 79 86 What is the total cost of a LEVEL aggregate plan?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Please help me answer and understand this. My head hurts already. Please provide the solution. Thank you so much.
In your own words, discuss the differences between a perpetual and periodic inventory system. Your discussion should refer to the differences in the recording process of inventory and the affected accounts.
Unplanned inventory decreases: tend to result in a decrease in income. tend to result in an increase in real output. tend to further reduce production. signal that demand was weaker than expected.
"Nordlund Boat Company has been repairing, refitting, and building custom boats. for over 60 years in the Pacific Northwest." The company is located in Tacoma, Washington. One of the engine's most critical components is the exhaust manifolds. The company purchases this item from the best manufacturers in the world. TJ is the buyer in charge of managing this item. TJ's purchasing agent currently submits an order release for this item every 4 weeks. The company's annual demand is 400 units (2 units per working day). Nordlund's relatively low volume and quality focus, rather than volume focus, means the company cannot take advantage of quantity discounts. The supplier has agreed to deliver this item within 1 week following an order release. For this reason, Nordlund has never had a shortage of exhaust manifolds. The total time between the release date and date of receipt is 1 week or 5 working days. The accounting has generated the following inventory-related costs. Procurement costs…
Algro Inc. keeps a wide range of parts and materials on hand for use in its production processes. Management has recently had difficulty managing parts inventory as demand for its finished goods has increased; they frequently run out of some critical parts while having an endless supply of others. They would like to classify their parts inventory according to the ABC approach to better control inventory. The following is a list of parts, along with their annual usage and unit value: Item Annual Unit Item Annual Unit Number Usage Cost Number Usage Cost 1 36 $350 2 510 30 3 50 23 4 300 45 5 18 1900 6 500 8 7 710 4 8 80 26 9 344 28 10 67 440 11 510 2 12 682 35 13 1216 95 50 14 10 3 15 820 1 KARAN2222222222 16 60 $610 17 120 20 18 270 15 19 45 50 20 19 3200 21 910 3 12 4750 23 30 2710 24 24 1800 25 870 105 26 244 30 27 750 15 28 45 110 29 46 160 30 165 25 a. Classify the inventory items according to the ABC approach using the dollar value of annual demand. b. Clearly explain why you…
Andy's Auto Dealership (AAD) is a family-run auto dealership selling both new and used vehicles. In an average month, AAD sells a total of 160 vehicles. New vehicles represent 60 percent of sales, and used vehicles represent 40 percent of sales. Max has recently taken over the business from his father. His father always emphasized the importance of carefully managing the dealership's inventory. Inventory financing was a significant expense for AAD. Max's father consequently taught him to keep inventory turns as high as possible. Examining the dealership's performance over recent years, Max discovered that AAD had been turning its inventory (including both new and used vehicles) at a rate of 8 times per year. What is AAD's average inventory (including both new and used vehicles)? Drilling down into the numbers, Max has determined that the dealerships new and used businesses appear to behave differently. He has determined that turns of new vehicles are 7.2 per year, while turns of used…
KGU company sells shoes whose daily demand is 100 units. The inventory holding cost is $2 per unit per year. The company also spends $20 per unit to process order. It takes 6 days from the time of reorder to the stocking of the inventory. The company keeps a safety stock that can cover twice the inventory. What is the ideal order quantity for KGU to purchase to minimize inventory costs? What is the ideal level of inventory at which KGU should pace a purchase order?
Jasmine owns 12 apartment buildings in a college town, which it rents exclusively to students. Each apartment building contains 120 rental units, but the owner is having cash flow problems due to an average vacancy rate of nearly 50 percent. The apartments in each building have comparable floor plans, but some buildings are closer to campus than others. Jasmine’s accumulated data from last year on the number of apartments rented, the rental price (in dollars), and the amount spent on advertising (in hundreds of dollars) at each of the 12 apartments are available below. These data, along with the distance (in miles) from each apartment building to campus, are presented below. Jasmine is looking for expert advice on the available data to inform administrative and business policy. By applying this scenario, help her regress the quantity demanded of her apartments on price, advertising, and distance datasets by using Excel or SPSS. Observation or (Number of Apartments) Quantity…
What are the primary benefits of implementing the Wilson approach in inventory control?
Please provide formula and answer
Please do not give solution in image formate thanku. Develop a production plan and calculate the annual cost for a firm whose demand forecast is fall, 10,000; winter, 8,000; spring, 7,000; summer, 12,000. Inventory at the beginning of fall is 500 units. At the beginning of fall, you currently have 30 workers, but you plan to hire temporary workers at the beginning of summer and lay them off at the end of summer. In addition, you have negotiated with the union an option to use the regular workforce on overtime during winter or spring if overtime is necessary to prevent stock outs at the end of those quarters. Overtime is not available during the fall. Relevant costs are hiring, $100 for each temp; layoff, $200 for each worker laid off; inventory holding, $5 per unit-quarter; backorder, $10 per unit; straight time, $5 per hour; overtime, $8 per hour. Assume that the productivity is 0.5 unit per worker hour, with eight hours per day and 60 days per season.
Pls help with below homework. Select the correct option and explain it in 7-8 sentences.