Question: Modify the Pigskin spreadsheet model in the following way. Assume that the timing of demand and production are such that only 70% of the production

Modify the Pigskin spreadsheet model in the following way. Assume that the timing of demand and production are such that only 70% of the production in a given month can be used to satisfy the demand in that month. The other 30% occurs too late in that month and must be carried as inventory to help satisfy demand in later months. How does this change the optimal production schedule? How does it change the optimal total cost? Then use SolverTable to see how the optimal production schedule and optimal cost vary as the percentage of production usable for this month’s demand (now 70%) is allowed to vary from 20% to 100% in increments of 10%.

Step by Step Solution

★★★★★

3.27 Rating (165 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style16 msonumberformat00220022000Red00220022000 msostylenameCurrency msostyleid4 style0 msonumberformatGeneral textaligngener... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

415-M-S-S-M (69).xlsx

300 KBs Excel File

Students Have Also Explored These Related Statistics Questions!

In laboratory situations, a projectiles range can be used to determine its speed. To see how this is done, sup-pose a ball rolls off a horizontal table and lands 1.5 m out from the edge of the table....

A laser beam can be used to weld, drill, etch, cut. And mark metals, as shown In Figure P5.3(a) [14]. Assume we have a work requirement for an accurate laser to mark a parabolic path with a...

A deburring robot can be used to smooth off machined parts by following a preplanned path (input command signal). In practice, errors occur due to robot inaccuracy, machining errors, large...

The Pigskin Company produces footballs. It must decide how many footballs to produce every month. The company has decided to use a 6-month planning horizon. The forecasted demands for the next 6...

1. List all of the constraints for the aggregate planning model using appropriate cell references. 2. Modify the aggregate planning model in the ff. way. Assume that the timing of demand and...

Spreadsheet Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six - month planning horizon. The forecasted monthly...

Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six - month planning horizon. The forecasted monthly demands for the...

Multiperiod production model \begin{tabular}{lr} Input data \\ Initial inventory \\ Holding cost as % of prod cost & 5000 \\ \end{tabular} \begin{tabular}{|l|c|c|c|c|c|c|} \hline Month & Month 1 &...

1.1. The manager of a small firm is considering whether to produce a new product that would require leasing some special equipment at a cost of $20,000 per month. In addition to this leasing cost, a...

Question 1) The Uptown Funk Corporation manufactures heavy duty air compressors for the home and light industrial markets. Uptown Funk is presently trying to plan its production and inventory levels...

There are 65 data values in a set. What is the suggested number of classes for a frequency table? A) 128 B) 64 OC) 7 OD) 6

The Fly Company provides advertising services for clients across the nation. The Fly Company is presently working on four projects, each for a different client. The Fly Company accumulates costs for...

4 a r c c o s ( 8 x ) 1 - 6 4 x 2 2 d x =

The following data give duration of unemployment by age, in July 1986. The economically active column gives the total of employed (not shown) plus unemployed in each age category. (a) In what sense...

A company uses a blanket overhead absorption rate of $5 per direct labour hour. Actual overhead expenditure in a period was as budgeted.The under/over-absorbed overhead account for the period have...

A company uses an overhead absorption rate of $3.50 per machine hour, based on 32,000 budgeted machine hours for the period. During the same period the actual total overhead expenditure amounted to...

Calculate the missing values for the promissory notes described in problem. Issue date Face value ($) Term Interest rate (%) Maturity value ($) Aug. 31 3 months 7.50 7644.86

Stray voltage is a serious problem on dairy farms, often resulting from corroded wiring or poor wiring practices. These conditions can produce several volts between the ground and metal watering...

A company purchased a drill press priced at $170,000 in year 0. The company additionally incurred $30,000 for site preparation and labor to install the machine. The drill press was classified as a...

During 2015, Becky loans her brother Ken $5,000, which he intends to use to establish a small business. Because Ken has no other assets and needs cash to establish the business, the agreement...

Assume the same facts as in Problem I:8-54, except that Becky and Ken are not related and that under the terms of the loan Ken agrees to repay Becky the $5,000 plus interest (at a reasonable stated...

Michelle and Mark are married and file a joint return. Michelle owns an unincorporated dental practice. Mark works part-time as a high school math teacher, and spends the remainder of his time caring...

Green Caterpillar Garden Supplies Inc. is a small firm, and several of its managers are worried about how soon the firm will be able to recover its initial investment from Project Sigma's expected...

One year ago you purchased 8 0 0 shares of Beta Company stock for $ 4 , 2 0 0 . The stock does not usually pay dividends, but Beta declared and paid its first dividend ever of $ 0 . 3 0 per share...

please help me figure out the last two and why they are wrong Rate of Return If State Occurs Stock A Stock B Stock C State of Economy Boom Normal Bust Probability of State of Economy .25 .50 .25 .35...