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
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
Inventory cost % (over production cost)
Unit production cost
Inventory after production
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 %
Purchase answer to see full