Reference no: EM131130413
This assignment is due on Friday, July15th at 11:59pm. The file (S16220ExcelAssign2) containing the data for this assignment can be found on Blackboard and your solution (by completing the worksheet containing the data and using Solver) is to be submitted through Blackboard.
The problem for this assignment is a production scheduling problem and is to be solved using the creative approach as illustrated in my creative Excel solution to problem 14 in chapter 4. That is, the solution should look similar to the following solution:
|
Q1
|
Q2
|
Q3
|
Q4
|
|
production cost/unit
|
$10,000
|
$11,000
|
$12,100
|
$13,310
|
|
demand
|
2000
|
4000
|
3000
|
1500
|
|
storage cost/unit
|
$250
|
$250
|
$300
|
$300
|
|
capacity
|
4000
|
3000
|
2000
|
4000
|
|
beginning inventory
|
100
|
|
|
|
|
|
|
|
|
|
beginning inventory
|
100
|
2100
|
1100
|
100
|
|
production
|
4000
|
3000
|
2000
|
1900
|
|
demand
|
2000
|
4000
|
3000
|
1500
|
|
ending inventory
|
2100
|
1100
|
100
|
500
|
|
|
|
|
|
|
total cost
|
$123,469,000
|
|
|
|
The scenario for this problem is as follows:
A manufacturer of ebikes wants to schedule its production over the next 3 quarters of the year so that it can minimize total production and storage costs over this period while meeting quarterly demands. The following table includes quarterly production capacities, quarterly demands, production costs per unit in each quarter, storage costs per unit in each quarter (based on ending inventory levels for that quarter) and the beginning inventory in quarter 1.
Quarter 1 Quarter 2 Quarter 3
production capacity 1400 1500 1000
quarterly demand 1000 1600 1100
production costs/unit $500 $525 $515
storage costs/unit $12 $13 $15
initial inventory
Based on this information and the need for at least 60 ebikes in inventory at the end of quarter 3, find the optimal solution that will allow the manufacturer to minimize total costs while satisfying the demands each quarter. If you solved this correctly, your total cost should be $1,921,390. You do not need to produce an answer or sensitivity report.
|
Martin snowplowing business dilemma
: Martin's service station is considering entering the snowplowing business in Freeport, Maine. Martin can purchase either a snowplow blade attachment for the station's pick-up truck or a new heavy-duty snowplow truck.
|
|
How will agencies be used to address the above requirements
: What individuals, groups, or delegations attending the UNGA meeting in New York are being targeted by domestic or international terrorists? What groups or individuals associated with criminal or terrorist activities are active in the New York area ..
|
|
Which statements concerning the cell cycle is false
: Which of the following statements concerning the cell cycle is FALSE? How does the first nucleotide at the 5' end of a new mRNA chain differ from the other nucleotides in the chain?
|
|
Why did you select your chosen point in the policy process
: Your response should indicate at what stage in the policy process it is most important to consider the impact of the Constitution, and your response should provide your support for your position.
|
|
A manufacturer of ebikes wants to schedule
: This assignment is due on Friday, July15th at 11:59pm. The file (S16220ExcelAssign2) containing the data for this assignment can be found on Blackboard and your solution (by completing the worksheet containing the data and using Solver) is to be s..
|
|
What is meant by comparative statics
: What is meant by comparative statics?
|
|
Explain how these policies and strategies are implemented
: How do national, state, and local agencies implement homeland security policies and strategies while accounting for the requirements of the U.S. Constitution and other laws? Explain in detail.
|
|
What is the small business administration sba
: What is the Small Business Administration (SBA), when was it organized, and what was its purpose?
|
|
A manufacturer ships toasters in cartons
: A manufacturer ships toasters in cartons of 50. In each carton, they estimate a 2% chance that one of the toasters will need to be sent back for minor repairs. In a batch of 25,000 toasters, what are the chances that fewer than 475 need to be retu..
|