Question: please solve through excel Model Inc. has to transport 100 bags of Type A bags, 100 bags of Type B bags, and 100 bags of

please solve through excel

Model Inc. has to transport 100 bags of Type A bags, 100 bags of Type B bags, and 100 bags of Type C bags. They can hire Truck and Mini vans. Each truck can carry 10 bags of Type A bags, 20 bags of Type B bags, and 10 bags of Type C bags. On the other hand, each minivan can carry 20 bags of Type A bags, 5 bags of Type B bags, and 10 bags of Type C bags. Each truck's rental cost is $1000 and each minivan's rental cost is $850. There are only 5 truck drivers available to drive the trucks(Hint: number of trucks should be less than or equal to 5 ). If Model Inc wants to minimize the transportation cost, how many trucks and vans should they rent? (Possible Answer: $9100 )

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

show it done through excel too PROBLEMI Model Inc. has to transport 100 bags of Type A bags, 100 bags of Type B bags, and 100 bags of Type C bags. They can hire Truck and Mini vans. Each truck can...

Please solve using excel A small candy shop is preparing for the holiday season. The owner must decide how many bags of deluxe mix and how many bags of standard mix of Peanut/Raisin Delite to put up....

How do I formulate question 3 as a transportation problem? ADM2302 Section M, N and P Solution Assignment # 2 SOLUTION Assignment # 2 LP Formulations and Applications ADM2302 students are reminded...

Spend analysis Stock-keeping unit (SKU) 10 Three-way match Utilization ty Images; @ monsity/ Getty Images Vendor master health care? iency? CHAPTER 17 applied, and what are the steps to fol-...

Please answer questions 1-10 based on the case. Please answer questions 1-10 In March 2011, Vishal Ramani, the inventory manager of sales and distribution for Toffee Inc., a confectionery company,...

Final Exam MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. Solve the problem. 1) The average age of the students in a statistics class is 22...

PLEASE SOLVE USING LINGO AND DO NOT COPY PREVIOUS ANSWERS. DO NOT USE EXCEL. (20 marks) Every operating day an oil refinery requires at least 2100 kilograms (kg) of chemical A, 2780kg of chemical B,...

Q. 1 (1) The magnitude of the vector drawn in a direction perpendicular to the surface +2y + at the point (1,-1,2)is(a)2/3(b)3/2(c)3(d)6 CLO-1 (5) (2) If u =x* +y* +2* and r =x +yj+zk, then...

Case Corp and Western Tech are two identical companies except for their capital structures. Neither firm pays taxes. Case Corp is unlevered and has 7,500 shares outstanding, each worth $25. Western...

When comparing two projects with diflerent Iives, why do you compule an annuty with an equivalent present value ( PV ) to the net present vabue ( NPV ) ? A . so that you can see which project has the...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...