Question: Would you please provide the answer in an excel spreadsheet showing formulas, and also the steps when completing the solver? Thank you LP Project 1

Would you please provide the answer in an excel spreadsheet showing formulas, and also the steps when completing the solver?
Thank you
Would you please provide the answer in an excel spreadsheet showing formulas,

LP Project 1 Instructions: Use the information given below to set up and solve a LP and provide the manager with the relevant information needed to make the optimal decision about how to move forward. You should be prepared to answer a few quiz questions about the initial optimal decision and results. You should also be prepared to change certain assumptions and then solve the problem for a new optimal decision. You will get credit for answering questions via an online quiz. You want to sell three additional items at your sculpture booth at the Cooper-Young Festival: wool dryer balls, wool scarfs, and wool hats. You crochet these items while watching Amazon Prime, sitting in waiting rooms, and at other idle times as a way to relax and make a little extra money which means over the summer you expect to have 296 hours. You purchased 70 skeins of wool yarn on clearance for $3.00 per skein and one 10 oz. box of roving. A wool dryer ball is a crocheted ball stuffed with wool roving. Each dryer ball uses 1 an ounce of roving which costs $0.75 and requires 1/10 of a skein of yarn for the ball itself and takes 1.5 hours to make. A scarf requires 2 skeins of yarn and takes 10 hours to make. A hat also requires 2 skeins of yarn and takes 12 hours to make. Based on last year's demand you want to have at least 8 of each of your projects available. You also observed that you sold twice as many scarfs as hats. You are able to sell the Dryer balls for $5.00 each, the Scarfs go for $25 each, and the Hats for $32.00 each. What should you crochet to make the most money

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 Accounting Questions!