Question: Question Completion Status: Question 5 Refer to the following spreadsheet mode. What does the Shipping costs and Order Size represent in the model? G H

Question Completion Status: Question 5 Refer to
Question Completion Status: Question 5 Refer to
Question Completion Status: Question 5 Refer to the following spreadsheet mode. What does the Shipping costs and Order Size represent in the model? G H A B D E F 1 Big M Company Distribution Problem 2 3 Shipping Cost 4 (per Lathe) Customer 1 Customer 2 Customer 3 5 Factory 1 $700 $900 $800 6 Factory 2 $800 $900 $700 7 8 Total 9 Shipped 10 Units Shipped Customer 1 Customer 2 Customer 3 Out 11 Factory 1 10 0 12 12 Factory 2 0 9 15 13 Total To Customer 10 9 14 15 Order Size 10 9 Output 12 15 CON Total Cost $20,500 Decision Variable Constraints Parameters Objective Function Question 6 2 points A Coffee shop manager is considering buying premade frozen pizzas and heat them in an oven to improve sales in the shop. The cost of the oven and freezer would be $32,000. The frozen puzzas cost $4.95 each to buy from a distributor and to prepare including labor and a box). To be competitive with the local delivery services, the manager believes they should sell the pizzas for $9.95 each Determine how many pizzas would have to be sold to break even I pizzas What is the total cost of selling 1000 pizzas? What is the total revenue of selling 1000 pizzas? . If they sell 25 pizzas per day, how many days would it take to break even? days

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!