Question: please solve and explain your work using excel program What'sBest! Sailco Corporation must determine how many sailboats should be produced during each of the next
please solve and explain your work using excel program What'sBest!
Sailco Corporation must determine how many sailboats should be produced during each of the next four quarters. The demand during each of the next four quarters is as follow: Sailco must meet demands on time. At the beginning of the first quarter, Sailco has an inventory of 10 sailboats. For simplicity, we assume that sailboats manufactured during a quarter can be used to meet demand for that quarter. During each quarter, Sailco can produce up to 40 sailboats with regular-time labor at a total cost of $400 per sailboat. By having employees work overtime during a quarter, Sailco can produce additional sailboats with overtime labor at a total coat of $450 per sailboat. At the end of each quarter, a carrying or holding cost of $20 per sailboat is incurred. The company needs to determine a production plan which minimizes the total production and inventory costs during the next four quarters. Solve the planning problem using What'sBest
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
