Question: please show excel formulas 2. Refer to sheet titled Q2. The data provides information for three items (Playground, Building, and Beach) produced by Ultimate Sand

please show excel formulas 2. Refer to sheetplease show excel formulas 2. Refer to sheetplease show excel formulas

2. Refer to sheet titled "Q2". The data provides information for three items (Playground, Building, and Beach) produced by Ultimate Sand Bags. A combination of 4 inputs are required to produce each bag of sand. The quantity of each input required to produce one bag of sand is shown, along with the quantity of each of the inputs available. Ultimate Sand Bags has also provide you with the profit per bag of each of their items. Based on this information, answer the following questions: a. What is your maximum profit? (2.5 points) b. How many of each item should you produce to maximize your total profit? Complete the table below: (2.5 points) C. Ultimate Sand Bags requires at least 30 bags of each type to be available inside their store. i. What is the new maximum profit with this requirement? (2.5 points) ii. How many of each item should you produce to maximize your total profit? Complete the table below: (2.5 points) ill. What resource(s) are binding on your total profit? (5 points) B 1 2 Inputs 3 Sand 4 Labor 5 Machine 6 Storage Sand Bag Output Requirements Playground Building Beach 5 6 3 24 5 2 4 1 Ovo Available Resources 9 Sand (pounds) 600 10 Labor (hours) 480 11 Machine (minutes) 600 12 Storage (bags) 150 13 Playground 15 Profit per bag $ 4.00 15 Profit per bag player to s Buildings Building 7.00 I $ Beach 7.00 Beach.co $ 16 17

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 General Management Questions!