The Shop at Home Network sells various household goods during live television broadcasts. The company owns...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Shop at Home Network sells various household goods during live television broadcasts. The company owns several warehouses to hold many of the goods it sells but also leases extra warehouse space when needed. During the next five months, the company expects it will need to lease the following amounts of extra warehouse space: Month sqft Needed 1 20,000 2 30,000 3 4 5 40,000 35,000 50,000 At the beginning of any month, the company can lease extra space for one or more months at the following costs: Lease term 1 2 3 4 5 (months) Cost per sqft $55 $95 $130 $175 $185 So, for instance, at the start of month 1 the company can lease as much space it wants for four months at a cost of $175 per sqft. Similarly, at the start of month 3, the company can lease any amount of space for two months at a cost of $95 per sqft. The company wants to determine the least costly way of meeting its warehousing needs over the coming five months. a. Formulate an LP model for this problem. (20 points) b. Create a spreadsheet model for this problem and solve it using Solver. (40 points) c. What is the optimal solution? (20 points) d. How much would it cost the company to meet its space needs if in each month it leases for one month exactly the amount of space required for the month? (20 points) Leased in month 1 2 3 4 5 1 2 Shop @ Home Through month 3 4. 5 Leasing costs $55 $95 $130 $175 $185 $55 $95 $130 $175 $55 $95 $130 $55 $95 $55 Total leasing cost Total Total Available Needed 20000 30000 40000 35000 50000 The Shop at Home Network sells various household goods during live television broadcasts. The company owns several warehouses to hold many of the goods it sells but also leases extra warehouse space when needed. During the next five months, the company expects it will need to lease the following amounts of extra warehouse space: Month sqft Needed 1 20,000 2 30,000 3 4 5 40,000 35,000 50,000 At the beginning of any month, the company can lease extra space for one or more months at the following costs: Lease term 1 2 3 4 5 (months) Cost per sqft $55 $95 $130 $175 $185 So, for instance, at the start of month 1 the company can lease as much space it wants for four months at a cost of $175 per sqft. Similarly, at the start of month 3, the company can lease any amount of space for two months at a cost of $95 per sqft. The company wants to determine the least costly way of meeting its warehousing needs over the coming five months. a. Formulate an LP model for this problem. (20 points) b. Create a spreadsheet model for this problem and solve it using Solver. (40 points) c. What is the optimal solution? (20 points) d. How much would it cost the company to meet its space needs if in each month it leases for one month exactly the amount of space required for the month? (20 points) Leased in month 1 2 3 4 5 1 2 Shop @ Home Through month 3 4. 5 Leasing costs $55 $95 $130 $175 $185 $55 $95 $130 $175 $55 $95 $130 $55 $95 $55 Total leasing cost Total Total Available Needed 20000 30000 40000 35000 50000
Expert Answer:
Related Book For
Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science
ISBN: 978-0324656633
5th edition
Authors: Cliff T. Ragsdale
Posted Date:
Students also viewed these accounting questions
-
When is an electronically - filed tax return considered "filed" by a tax preparer? A ) When electronically submitted to the IRS B ) 4 8 hours after submission C ) Five business days after submission...
-
The Shop at Home Network sells various household goods during live television broadcasts. The company owns several warehouses to hold many of the goods it sells, but also leases extra warehouse space...
-
CASE STUDY: Imax Back in 1997 the CEO of IMAX, Richard L. Gelfond, was sceptical about building a story with Hollywood movie stars into the big screen format. At that time his answer to the criticism...
-
Write a SET client SpellChecker that takes as a commandline argument the name of a file containing a dictionary of words, and then reads strings from standard input and prints any string that is not...
-
Here's another table showing information on 348 movies released in 2010. This table gives percentages of the overall total: a) How can you tell that this table holds overall percentages (rather than...
-
The accompanying table shows the low price, the high price, and the average price of homes sold in 15 communities in San Luis Obispo County between January 1, 2004, and Au gust 1, 2004 (San Luis...
-
Organization. Explain the change in the foreign exchange market from a two-tier (interbank/wholesale and client/retail) market to a single-tier market.
-
Realtors, Inc., specializes in the sale of residential properties. It earns its revenue by charging a percentage of the sales price. Commissions for sales persons, listing agents, and listing...
-
Q1) Common-Law Liability Exposure. Smith, CPA, is the auditor for Juniper Manufacturing Corporation, a nonpublic entity that has a June 30 fiscal year. Juniper arranged for a substantial bank loan,...
-
A parent sells land costing $50,000 to a subsidiary in 2016 for $95,000. The subsidiary sells the land in 2018 to a third party for $130,000. On the consolidated income statement for 2018, the gain...
-
Answer the following question in no more than 2 sentences See the following figure Why do you believe there has been a sharp increase in the BBSW in recent times. Provide two reasons....
-
Divide using synthetic division. 2x3+5x2-5x+7 X-3
-
Write a program in C# Sharp to read 10 numbers from keyboard and find their sum and average Hint: use for loop Sample Output: I/P: 2, 4, 6, 8, 10, 12, O/P: Sum is 110 Avg is 11 20
-
How did Netflix's relationship with filmmakers lead to mutual dependence?
-
A home improvement company is interested in improving customer satisfaction rate from the 70% currently claimed. The company sponsored a survey of 192 customers and found that 143 customers were...
-
A Risk Breakdown Structure is limited to Project Management and Organizational sources of risk. Review Later True False
-
If the amplifier indicated by the box input impedance of oo, which of the following statements are true ? has an open loop gain as well as Feedback factor (\beta = 1/ R_1\) The feedback is voltage...
-
Assume that you own and manage a small clothing store. A. What kinds of financial information would you want to run your business? B. What kinds of nonfinancial information would you want (for...
-
One of the first U.S. major industries to be regulated was the railroads. Farmers and manufacturers depended on railroads to get their products to market, and often there was only one railroad...
-
The chapter indicates that two very different objectives of accounting are to provide useful information for making decisions about the future, and to provide accountability for what happened in the...
Study smarter with the SolutionInn App