Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

During the next two months an automobile manufacturer must meet (on time) the following demands for trucks and cars: month 1, 400 trucks and 800

During the next two months an automobile manufacturer must meet (on time) the following demands for trucks and cars: month 1, 400 trucks and 800 cars; month 2, 300 trucks and 300 cars. During each month at most 1000 vehicles can be produced. Each truck uses two tons of steel, and each car uses one ton of steel. During month 1, steel costs $700 per ton; during month 2, steel is projected to cost $800 per ton. At most 2500 tons of steel can be purchased each month. (Steel can be used only during the month in which it is purchased.) At the beginning of month 1, 100 trucks and 200 cars are in the inventory. At the end of each month, a holding cost of $200 per vehicle is assessed. Each car gets 20 miles per gallon (mpg), and each truck gets 10 mpg. During each month, the vehicles produced by the company must average at least 16 mpg.

a. Determine how to meet the demand and mileage requirements at minimum total cost.

Production Schedule Month 1 Month 2
# Cars
# Trucks
Steel Purchased (tons)

What is the company total cost? $

b. Use SolverTable to see how sensitive the total cost is to the 16 mpg requirement. Specifically, let this requirement vary from 14 mpg to 18 mpg in increments of 0.25 mpg. Explain intuitively what happens when the requirement is greater than 17 mpg. Round your answers to the nearest whole number, if necessary.

The total cost Selectincreasesdecreasesstays constantItem 8 as long as the average fuel efficiency requirement does not exceed mpg. The model will produce SelectinfeasiblefeasibleItem 10 solutions when the required fuel efficiency is above mpg.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Accounting

Authors: Heintz and Parry

20th Edition

1285892070, 538489669, 9781111790301, 978-1285892078, 9780538489669, 1111790302, 978-0538745192

More Books

Students also viewed these Accounting questions

Question

6. How can hidden knowledge guide our actions?

Answered: 1 week ago