Question: 2. Linear Programming - See the attached spreadsheet. a. What are the optimal quantities of each to make? b. What are the optimal profits? c.

2. Linear Programming - See the attached

2. Linear Programming - See the attached spreadsheet.

a. What are the optimal quantities of each to make?

b. What are the optimal profits?

c. What is the most they would pay for another unit of cranberries?

f. How much would the optimal quantities change if the profit per tart were $1.00? (choose one)

a. We cannot tell with the information we have. The LP would need to be re-solved.

b. No change - the decrease is within the allowable range

c. The optimal quantity would increase to 195

d. The optimal quantity would decrease to 105

Profits Scones Cookies Tarts 2.5 1.5 1.95 20 84.5 10 10 1 1 1 1 1 s.t. Full Case Cranberry supply Chocolate supply Baking time Flour supply Sugar supply Apple filling supply 0.75 0.5 1.25 2.5 1 1 40 >= 40 items 20 =$G$6 Not Binding 24.5 40 $E$7

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!

Attached, kindly find SNHU Course material for QSO-320 Management Science Spreadsheet Management - Milestone Four. Thank you! QSO 320 Final Project Guidelines and Rubric Overview The final project...

BUSINESS 275, WINTER 2016 ASSIGNMENT #2: LINEAR PROGRAMMING Administrative Matters 1.1 Deadline This assignment is due by 11 AM on Wednesday, March 23, 2016 in the correct labeled drop box outside...

How can I solve this question via Excel Problem 2. Sensitivity Analysis at Stickley Furniture Stickley Furniture is a manufacturer of fine hand-crafted furniture. During the next production period,...

#3 Case Problem Julia's Food Booth A: Formulation of the LP Model X1(Pizza), X2(hotdogs), X3(barbecue sandwiches) Constraints: Cost: Maximum fund available for the purchase = $1500 Cost per pizza...

Why am I not getting the correct answer for 7.18. I have included solver and formulas. Can someone please help cells b18 to F18 are.. Total Shipped column =SUM(B13:B17) =SUM(C13:C17) =SUM(D13:D17)...

The RBC (Royal Bank of Canada) uses online banking to market two new banking products. The first product is a home risk insurance that allows buyers to default for up to 6 months on their mortgage...

a Problem 2. Sensitivity Analysis at Stickley Furniture Stickley Furniture is a manufacturer of fine hand-crafted furniture. During the next production period, management is considering producing...

Luna, Eta, and Park are the sole partners in a local company that makes stand-out clocks. Luan and Eta are each available to work a maximum of four hours a week at the company while Park is available...

PLEASE HELP PROBLEM 8-31!!! ASSEM- ble. Would this product be economically attractive to manufacture if the sales price were $86? Why or why not? 3-28 The Classic Furniture Company is trying to...

The ABC Company produces magnetic letters at three different plants which serves four separate markets. The companys plants are located in New York, Chicago and Los Angeles. Product produced at the...

Figure 1 below shows the price and other information of an Apple bond from the site Investing.com Figure 1: Apple 3.85% bond information (from Investing.com) as of 22 July 2022 Apple Inc AAPL 3.85%...

A company operating in a mature industry with few opportunities for growth or expansion will generally report negative cash flow from financing activities. Why? Where might this cash be going?

5. (LO3) Suppose you are flipping a fair coin in a coin-flipping contest and have flipped eight heads in a row. What is the probability of flipping a head on your next coin flip? Suppose you flipped...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...