need your assistance with solver. I have some of the answers but not sure how to put it in the solver application. I have attached the questions, answers and the spreadsheet with solver (I think). thanks for your help.

1-26 A start-up publishing company estimates that the fixed costs of its first major project will be $190,000, the variable cost will be $18, and the selling price per book will be $34. (a) How many books must be sold for this project to break even? (b) Suppose the publishers wish to take a total of $40,000 in salary for this project. How many books must be sold to break even, and what is the break-even point, in dollars? 1-28 A distributer of prewashed shredded lettuce is opening a new plant and considering whether to use a mechanized process or a manual process to prepare the product. The manual process will have a fixed cost of $43,400 per month and a variable cost of $1.80 per 5-pound bag. The mechanized process would have a fixed cost of $84,600 per month and a variable cost of $1.30 per bag. The company expects to sell each bag of shredded let- tuce for $2.50. (a) Find the breakeven point for each process. (b) What is the monthly profit or loss if the company chooses the manual process and sells 70,000 bags per month? 1-30 Bismarck Manufacturing intends to increase capac- ity through the addition of new equipment. Two vendors have presented proposals. The fixed cost for proposal A is $65,000, and for proposal B, $34,000. The variable cost for A is $10, and for B, $14. The revenue generated by each unit is $18. (a) What is the break-even point for each proposal? (b) If the expected volume is 8,300 units, which alternative should be chosen? Problem 1-26 PART A: Without salary Known parameters: Selling price per unit Fixed cost Variable cost per unit PART B: With salary $34.00 $190,000.00 $18.00 Known parameters: Selling price per unit Fixed cost Variable cost per unit Input Data Number of units, X Input Data Number of units, X Results Total revenue Fixed cost Total variable cost Total cost Profit Results Total revenue Fixed cost Total variable cost Total cost Profit Question A: How many books must be sold for tis project to break even? 6,250 Question B, 1st part: How many books must be sold to break even? Answer A: see page 12 for BEP equation 1-2 BEP = fixed cost / (selling price per unit - variable cost per unit) BEP = 14,375 BEP = Question B, 2nd part: what is the BEP in dollars? see page 12 for BEP equation 1-3 BEP$ = Fixed cost + (Variable cost per unit X BEP} BEP$ = $34.00 $230,000.00 $18.00 Please use Goal Seek in yellow fields (see section 1.5) Please use Excel equations in the green & orange fields fields books must be sold to break even? BEP in dollars? 12 for BEP equation 1-3 xed cost + (Variable cost per unit X BEP} Problem 1-28 Manual process Mechanized process Known parameters: Selling price per unit Fixed cost Variable cost per unit Known parameters: Selling price per unit Fixed cost Variable cost per unit $2.50 $43,400.00 $1.80 Input Data Number of units, X Input Data Number of units, X Results Total revenue Fixed cost Total variable cost Total cost Profit Results Total revenue Fixed cost Total variable cost Total cost Profit $43,400.00 $2.50 $84,600.00 $1.30 $84,600.00 Question - Manual process: what is the break even point (BEP)? Question - Mechanized process: what is the break even point (BEP)? Answer - Manual process: see page 12 for BEP equation 1-2 Answer - Manual process: see page 12 for BEP equation 1-2 BEP = 62,000 43,400/(2.5-1.8) BEP = 70,500 84,600/1.2 Enter values from probl Enter values from problem given Please use Goal Seek in yellow fields (see section 1.5) Please use Excel equations in the green & orange fields fields Problem 1-28 Manual process Known parameters: Selling price per unit Fixed cost Variable cost per unit $2.50 $43,400.00 $1.80 Input Data Number of units, X Results Total revenue Fixed cost Total variable cost Total cost Profit Question: What is the monthly profit or loss if the company chooses the manual process and sells 70,000 bags per month? Answer: company will profit = ags per month? Problem 1-30 Proposal A Known parameters: Selling price per unit Fixed cost Variable cost per unit Proposal B $18.00 $65,000.00 $10.00 Known parameters: Selling price per unit Fixed cost Variable cost per unit $18.00 $34,000.00 $14.00 Input Data Number of units, X Input Data Number of units, X Results Total revenue Fixed cost Total variable cost Total cost Profit Results Total revenue Fixed cost Total variable cost Total cost Profit Question - Proposal A: what is the break even point (BEP)? Question - Proposal B: what is the break even point (BEP)? Answer - Manual process: see page 12 for BEP equation 1-2 Answer - Manual process: see page 12 for BEP equation 1-2 BEP = BEP = Problem 1-30 Proposal - Alternative A Proposal - Alternative B Known parameters: Selling price per unit Fixed cost Variable cost per unit Known parameters: Selling price per unit Fixed cost Variable cost per unit Input Data Number of units, X Input Data Number of units, X Results Total revenue Fixed cost Total variable cost Total cost Profit Results Total revenue Fixed cost Total variable cost Total cost Profit Question: Which alternative proposal should be chosen? B