# excel questions

p1 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.
How many books must be sold for this project to break even?
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?
p2 3-3
A manufacturer of travel pillows must determine the production plan for the next production cycle. He wishes to make at least 300 of each of the three models that his firm offers and no more than 1,200 of any one model. The specifics for each model are shown in the following table. How many pillows of each type should be manufactured in order to maximize total profit?
Pillow Model Selling Price Cutting Sewing Finishing Packing
Junior travel pillow \$5.75 0.10 0.05 0.18 0.20
Travel pillow \$6.95 0.15 0.12 0.24 0.20
Deluxe travel pillow \$7.50 0.20 0.18 0.20 0.20
Available hours 450 550 600 450
Cost per hour \$7.00 \$9.00 \$8.50 \$7.25

1. Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount