(Answered)-Write the formulas that calculate the gross revenue (number - (2025 Updated Original AI-Free Solution

Question

1. Write the formulas that calculate the gross revenue (number purchased multiplied by the retail price), the total unit cost (unit cost multiplied by the number purchased), the total storage cost (storage cost per unit multiplied by the number purchased), the total cost (total unit cost plus total storage cost),and the profit (gross revenue minus the total cost).
2. Enter a mathematical formula in the objective cell, and then check that formulas entered in step 1 link the objective cell with the variable cells. ?Add sample values to the variable cells to ensure that your worksheet is set up correctly and produces the expected results.
3. Create a constraint table in the worksheet that identifies the constraints in this problem.
4. Use Solver to determine the best way to purchase the power blocks sets and kits, and maximize the profit.
5. Produce a Feasibility report to troubleshoot the solution to determine how the cost and quantity constraints caused the solution to be infeasible.
   1. In order to complete the solution this step to produce a feasibility report, you must run the solver model again without the integer constraint.
6. Save you solver model as a scenario named Purchase Plan 1
7. Betty tells you that she cannot increase the available budget and asks you to change the constraints to maximize the profit. ?She also asks you to keep the constraints to purchase more sets than kits and to purchase at least half as many power block outdoor sets as power blocks urban adventure sets. ?She also wants you to purchase at least 7250 total items.
   1. Update your constraints table and the solver model with your changes, and then run the solver again. ?If necessary, adjust your constraints until you find a feasible solution. ?Save your solver model as a scenario named purchase plan 2. ?
8. Produce?an?answer?report?of?your?final?solution.??Use?the?answer?report?to?recommend?any?additional?changes?that?might?maximize?the?total?profit.??Place?your?recommendations?in?a?text?box?on?the?answer?report?worksheet.

I know the starting price is low, but the last tutor accepted it and did nothing for a week, so I am still waiting for my $40 refund, it will total to $60 if completed thank you

Skills covered in this problem:
Analyze data by creating and running a Solver model
Interpret an answer report
Identify feasible and infeasible solutions
Troubleshoot an infeasible solution

Power Blocks Purchasing Plan

Power Blocks Urban Adventure Set
Turbo Action Kit
Power Blocks Outdoor Set
Camping Kit

Constraints
Total Cost (I8)
Power Blocks Urban Adventure Set (B4)
Turbo Action Kit (B5)
Power Blocks Outdoor Set (B6)
Camping Kit (B7)
Number Purchased (B4:B7)
Turbo Action Kit (B5)
Camping Kit (B7)
Total Number Purchased

Number
Purchased
1
1
1
0

$
$
$
$

Retail Price
19.95
14.95
16.95
11.95

Gross Revenue

Unit Cost
$ 15.36
$ 14.21
$ 13.77
$ 10.03

Total Unit Cost

Storage Cost
per Unit
Total Storage Cost
$
0.15
$
0.10
$
0.25
$
0.15
Total

Total Cost

Profit