Question
1. Binford Tools manufactures garden tools. It uses inventory, overtime, and subcontracting to absorb demand fluctuations. Expected demand, regular and overtime production capacity, and subcontracting
1. Binford Tools manufactures garden tools. It uses inventory, overtime, and subcontracting to absorb demand fluctuations. Expected demand, regular and overtime production capacity, and subcontracting capacity are provided in the following table for the next four quarters for its basic line of steel garden tools:
Regular Overtime Subcontracting
Quarter Demand Capacity Capacity Capacity
1 9,000 9,000 1,000 3,000
2 12,000 10,000 1,500 3,000
3 16,000 12,000 2,000 3,000
4 19,000 12,000 2,000 3,000
The regular production cost per unit is $20, the overtime cost per unit is $25, the cost to subcontract a unit is $27, and the inventory carrying cost is $2 per unit. The company has 300 units in inventory at the beginning of the year. Determine the optimal production schedule for the four quarters to minimize total costs.
This is the second time I am posting this question please answer only if you can show clear work with full steps and formulas on excel sheet
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started