*********Please help me with the formulas in excel so I can get the correct answers. This is my example problem and the answers are below, but I want to figure it out using excel. Thank you. Please show your excel sheet with and without formulas so I can understand. ********* I've entered most in and my formulas are above but now I'm stuck. Help please.

A.J.'s Wildlife Emporium manufactures two unique birdfeeders (Deluxe and Super Duper) that are manufactured and assembled in up to three different workstations (X, Y, and Z) using a small batch process. Each of the products is produced according to the flowchart below. Additionally, the flowchart indicates each product's price, weekly demand, and processing times per unit. Batch setup times are negligible. A.J. can make and sell up to the limit of its weekly demand and there are no penalties for not being able to meet all of the demand. Each workstation is staffed by a worker who is dedicated to work on that workstation alone and is paid $20 per hour. The plant operates 40 hours per week, with no overtime. Overhead costs are $1,800 per week. Based on the information provided, as well as the information contained in the flowchart, answer the following questions. Deluxe $10 -- Step 1 Step 3 Station Z (36 min) Step 2 Station Y (20 min) Station X (18 min) Product: Deluxe Price: $90/unit Demand: 42 units/wk Raw materials $12 Purchased part Super Duper $6 Step 1 Step 3 7 Station X (36 min) Step 2 Station Z (12 min) Station Y (24 min) Product: Super Duper Price: $85/unit Demand: 51 units/wk Raw materials $7 Purchased part A B D E F G H 1 Deluxe Super Duper Total Load Available Time Bottleneck 36 Station 2 3 X 4 Y 5 Z 6 Unit Demanded 7 18 20 2592 2064 2124 24 12 51 2400 YES 2400 2400 36 42 Bottleneck Method Traditional Method Profit Per Unit Profit Per Min. Priority Sequence Profit Per Unit Priority Sequence 1 2 68 72 3.78 2.00 68 72 2 1 Load from Deluxe Load from Super Duper Total Load 756 1836 2592 840 1224 2064 1512 612 2124 X Y z 42 Product Selling Price Mat. Cost 8 9 Deluxe 90 22 10 Super Duper 85 13 11 12 Bottleneck 13 Product Super Duper Deluxe 14 Units Produced 51 15 Time Utilized 16 Time Remaining 17 Profit 18 Traditional 19 Product Deluxe Super Duper 20 Units Produced 51 21 Time Utilized 22 Time Remaining 23 Profit 24 Change in Profit 25 42 A B D E F G H 1 Super Duper Total Load Available Time Bottleneck YES Station Deluxe 2 3 X 18 4 Y 20 5 Z 36 6 Unit Demanded 42 7 36 24 12 51 =SUMPRODUCT(B3:03,$B$6:$D$6) 2400 =SUMPRODUCT(B4:04,$B$6:$D$6) 2400 =SUMPRODUCT(B5:05,$B$6:$D$6) 2400 Bottleneck Method Traditional Method Profit Per Unit Profit Per Min. Priority Sequence Profit Per Unit Priority Sequence =B9-09 =B10-C10 =D9/3 =D10/C3 1 2 =B9-C9 =B10-C10 2 1 Load from Deluxe Load from Super Duper Total Load XI=C14 B3 =B14C3 =E3 Y =C14 B4 =B14C4 =E4 Zl=C14C3 =B14*C5 =E5 Product Selling Price Mat. Cost 8 9 Deluxe 90 22 10 Super Duper 85 13 11 12 Bottleneck 13 Product Super Duper Deluxe 14 Units Produced =C6 =B6 15 Time Utilized 16 Time Remaining 17 Profit 18 Traditional 19 Product Deluxe Super Duper 20 Units Produced =B6 =C6 21 Time Utilized 22 Time Remaining 23 Profit 24 Change in Profit 25 26 27 28 a. Using the traditional method, which bases decisions solely on a product's contribution to profits and overhead, what is the optimal product mix and what is the overall profitability? Thus, the optimal product mix is as follows. Deluxe: 31 units/week, Super Duper: 51 units/week. Added value $2,108 + $3,672 Labor - 3 workers(40 hours)($20/hour) Overhead - $1,800 Total = $1,580 b. Using the bottleneck-based method, what is the optimal product mix and what is the overall profitability? Thus, the optimal product mix is as follows. Deluxe: 42 units/week, Super Duper: 45 units/week. Now that the product mix is obtained, compute its profitability. Total Price (per Materials and parts Production (units) unit) (per unit) 42 Deluxe $90 - $10-$12 45 Super Duper $85 - $6 - $7 = $2856 $3240 = Thus, the product mix obtained using the bottleneck method yields a profit of $2856 + $3240 - $2400 $1,800 = $1,896