Question

In: Accounting

Astro Winter LLC makes snowplowing equipment. The company buys the engines from a 3rd party vendor...

Astro Winter LLC makes snowplowing equipment. The company buys the engines from a 3rd party vendor – Marshall Engines. Astro Winter has the following production schedule for February, March, April, and May: February – 60; March – 85; April 100; May – 120. Marshall Engines makes and delivers the products to Astro Winter during the month the engines are due. Marshall Engines can only manufacture 40 engines in February; 60 in March; 90 in April; and 50 in May. During the same time that Astro Winter makes their snowplows, Marshall Engines has a large order with another client. Marshall Engine is exploring several options to meet Astro Winter’s production schedule. It can produce up to 30 engines in November, December, and January and carry them in inventory at a cost of $50 per engine per month until it ships them to Astro Winter. For instance, Marshall could build an engine in November, and deliver it to Astro Winter in February and incur $150 in inventory cost. Marshal Engines could also manufacture up to 20 engines in the month they are due on an overtime basis, with an additional cost of $400 per engine. Marshall Engine wants to determine the least costly production schedule that will meet Astro Winter’s schedule.

Instructions: SOLVE USING EXCEL QM!!!!

1) Develop the LP model and determine the optimal production schedule for Marshall Engine.

2) If Marshall Engine were able to increase their production capacity in November, December, and January from 30 to 40 engines, what will be the impact on the optimal solution? Explain your answer.

Solutions

Expert Solution

Solution;+


Related Solutions

Please show me how to do this with Excel QM, not Solver. Astro Winter LLC makes...
Please show me how to do this with Excel QM, not Solver. Astro Winter LLC makes snowplowing equipment. The company buys the engines from a 3rd party vendor – Marshall Engines. Astro Winter has the following production schedule for February, March, April, and May: February – 60; March – 85; April 100; May – 120. Marshall Engines makes and delivers the products to Astro Winter during the month the engines are due. Marshall Engines can only manufacture 40 engines in...
From the QuickBooks Accounting Software for Accountants window, select 3rd Party Apps. From the Apps featured,...
From the QuickBooks Accounting Software for Accountants window, select 3rd Party Apps. From the Apps featured, select your favorite. Summarize for your accounting clients why you consider your choice a worthwhile app for QuickBooks.
What sort of actions could the company has undertaken to protect the 3rd party audit ?...
What sort of actions could the company has undertaken to protect the 3rd party audit ? and What detail should you provide to OSHA when discussing the audit findings?
Without a guarantee from the vendor, how can a company take advantage of the vendor financing...
Without a guarantee from the vendor, how can a company take advantage of the vendor financing without moving to the verdor's country.
Nick Warf, the company president, has found a vendor for the equipment. Clapton Acoustical Equipment has...
Nick Warf, the company president, has found a vendor for the equipment. Clapton Acoustical Equipment has offered to sell Warf Computers the necessary equipment at a price of $4 million. Because of the rapid development of new technology, the equipment falls in the three-year MACRS depreciation class. At the end of four years, the market value of the equipment is expected to be $480,000. Alternatively, the company can lease the equipment from Hendrix Leasing. The lease contract calls for four...
Troy Engines, Ltd., manufactures a variety of engines for use in heavy equipment. The company has...
Troy Engines, Ltd., manufactures a variety of engines for use in heavy equipment. The company has always produced all of the necessary parts for its engines, including all of the carburetors. An outside supplier has offered to sell one type of carburetor to Troy Engines, Ltd., for a cost of $35 per unit. To evaluate this offer, Troy Engines, Ltd., has gathered the following information relating to its own cost of producing the carburetor internally: Per Unit 22,000 Units per...
Troy Engines, Ltd., manufactures a variety of engines for use in heavy equipment. The company has...
Troy Engines, Ltd., manufactures a variety of engines for use in heavy equipment. The company has always produced all of the necessary parts for its engines, including all of the carburetors. An outside supplier has offered to sell one type of carburetor to Troy Engines, Ltd., for a cost of $39 per unit. To evaluate this offer, Troy Engines, Ltd., has gathered the following information relating to its own cost of producing the carburetor internally: Per Unit 21,000 Units Per...
Troy Engines, Ltd., manufactures a variety of engines for use in heavy equipment. The company has...
Troy Engines, Ltd., manufactures a variety of engines for use in heavy equipment. The company has always produced all of the necessary parts for its engines, including all of the carburetors. An outside supplier has offered to sell one type of carburetor to Troy Engines, Ltd., for a cost of $36 per unit. To evaluate this offer, Troy Engines, Ltd., has gathered the following information relating to its own cost of producing the carburetor internally: * 1/3 supervisory salaries; 2/3...
Troy Engines, Ltd., manufactures a variety of engines for use inheavy equipment. The company has...
Troy Engines, Ltd., manufactures a variety of engines for use in heavy equipment. The company has always produced all of the necessary parts for its engines, including all of the carburetors. An outside supplier has offered to sell one type of carburetor to Troy Engines, Ltd., for a cost of $36 per unit. To evaluate this offer, Troy Engines, Ltd., has gathered the following information relating to its own cost of producing the carburetor internally: Per Unit 20,000 Units Per...
Troy Engines, Ltd., manufactures a variety of engines for use inheavy equipment. The company has...
Troy Engines, Ltd., manufactures a variety of engines for use in heavy equipment. The company has always produced all of the necessary parts for its engines, including all of the carburetors. An outside supplier has offered to sell one type of carburetor to Troy Engines, Ltd., for a cost of $35 per unit. To evaluate this offer, Troy Engines, Ltd., has gathered the following information relating to its own cost of producing the carburetor internally: Per Unit 22,000 Units Per...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT