Question: I need help with all the problem. please solve using excel showing calculations/operations. Harold is considering starting a sandwich-making business to earn some extra income.

I need help with all the problem. please solve using excel showing calculations/operations. I need help with all the problem. please solve
Harold is considering starting a sandwich-making business to earn some extra income. Harold divides his needs into three areas: breads, meats and cheeses, and condiments. He estimates that he will be able to use all the products he purchases before they spoil, so perishability is not a relevant issue. The demand and cost parameters are as follows. +1 The fixed order cost is $6.00 every time an order is placed. Assume that holding costs are based on an annual interest rate of 25 percent and that a year has 52 weeks. a) Find the optimal quantities that Harold should purchase of each type of product when they are ordered independently and calculate the total annual order and holding. b) Find the optimal quantities that Harold should purchase of each type of product when all products are ordered at same time and calculate the total annual order and holding. c) Find the optimal quantities that Harold should purchase of each type of product when products are ordered jointly but not every order contains every product and calculate the total annual order and holding. d) Compare the total annual costs from a, b, and c. Which policy is better

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!