Select Page

Answer & Explanation:solve with formulas the following questions #1-3https://books.google.com/books?id=_wja8C5MogEC&pg=PT842&lpg=PT842&dq=pigskin+football+excel&source=bl&ots=Eioadx1OMH&sig=66FwFaL6RSp8Cu47Nu3BvT42DGc&hl=en&sa=X&ved=0ahUKEwis7bnZiJDPAhWBQiYKHQyPAYQQ6AEIIjAB#v=onepage&q=pigskin%20football%20excel&f=falselook at example 14.3 page 825 it is the same as the example problem
20160915003150example_problem.xlsx

Unformatted Attachment Preview

Pigskin must decides how many footballs to produce each month for 6
satified on time. Set a model to determine the production plan for next 6 m
1. Complete the spreadsheet model with appropriately named ranges. Base
production in next 6 months? What is the minimal total cost?
2. If 6-month rolling planning horizon is adopted, we hope the forecast erro
limited on month 1 production. Do the test, and comment on whithin what
is good to use.
3. At the current inventory cost of 5%, will the storage limit be ever reached
will the storage limit be reached?
Produce footballs at Pigskin
Input data
Inventory cost % (over production cost)
Month
1
Unit production cost
\$12.50
Demand
10,000
Initial inventory
5,000
Capacity
30,000
Storage limit
10,000
Constraints
Month
5%
2
\$12.55
15,000
3
\$12.70
30,000
4
\$12.80
35,000
5
\$12.85
25,000
6
\$12.95
10,000
1
2
3
4
5
6
1
2
3
4
5
6
Initial inventory
Capacity
Units produced
Inventory after production
Demand
Ending inventory
Storage limit
Output variables
Month
Production cost
Inventory cost
Monthly cost
Total cost
month for 6-month planning horizon. Monthly demand must be
plan for next 6 months which incurs the least total cost.
med ranges. Based on the model, how should you plan the
he forecast errors in month 5 and month 6 will impact very
on whithin what error range, the 6-month rolling planning horizon
be ever reached in any month? If not, at what inventory cost %