Question: PLEASE USE EXCEL AND UPLOAD THE EXCEL SHEET A wood product firm uses leftover time at the end of each week to make goods that

PLEASE USE EXCEL AND UPLOAD THE EXCEL SHEET A

PLEASE USE EXCEL AND UPLOAD THE EXCEL SHEET

A wood product firm uses leftover time at the end of each week to make goods that are stocked. Currently, two products on the list of the items are produced for stock: a chopping board and knife holder. Both items require three operations: cutting, gluing, and finishing. The manager of the firm has collected the following data on these products Time per unit (minutes) Item Cutting Gluing. Finishing Chopping board 1.4 5 12 Knife holder 0.8 13 3 The manager also determined that, during the week, 56 minutes are available for cutting, 650 minutes are available for gluing, and 360 minutes are available for finishing. The Chopping board has a profit of $4 per unit, and Knife holder has a profit of $6 per unit. a. What is the optimal number of Chopping boards and? b. What is the optimal total profit? C. How much of the total profit can change if 100 minutes of finishing becomes available for no cost? Explain. d. What would be your recommendation as to whether the firm, increase its cutting time by 10 minutes for the total cost of $12? Explain

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!

Provide a written answer for each part. Submissions after 11:59 PM 12/7/2021 is not accepted and receives a grade of zero. A wood product firm uses leftover time at the end of each week to make goods...

1. (Linear Programming: basic formulation and graphical solution) A wood product firm uses available time at the end of each week to make goods for stock. Currently, two products on the list of items...

1 . ( 2 5 pts . ) A wood product firm uses available time at the end of each week to make goods for stock. Currently, two products on the list of items are produced for stock: a chopping board and a...

Use the following to answer questions 5 - 7 : A wood products firm uses available time at the end of each week to make goods for stock. Currently, two products on the list of items are produced for...

For each problem, clearly state the decision variables, the objective function, and the constraints. You must present the LP formulation for each problem in the format presented in the class notes....

A wood products firm uses leftover time at the end of each week to make goods for stock. Currently, there are two products on the list of items that are produced for stock: a chopping board and a...

A wood product firm uses available time at the end of each week to make goods for stock. Currently, two products on the list of items are produced for stock: a chopping board and a knife holder. Both...

Use the following to answer questions 5-7: A wood products firm uses available time at the end of each week to make goods for stock. Currently, two products on the list of items are produced for stock

Chapter 19 Exercises 1. A wood products firm uses available time at the end of each week to make goods for stock. Currently, two products on the list of items are produced for stock: a chopping board...

A 5.47-kg ball hangs from the top of a vertical pole by a 2.09-m-long string. The ball is struck, causing it to revolve around the pole at a speed of 4.49 m/s in a horizontal circle with the string...

Can cash flow from operations be positive if net income is negative? Can it be negative if net income is positive? Give examples.

In valuing the schooner Alvin Clark, Bruce Closser applied Group of answer choices only the cost approach only the sales comparison approach only the income approach two of the three possible...

I have a rather large accounting problem it has 5 different sections to it. I am uploading the file and would appreciate help and direction withit. Thank you!! Hansell Company's management wants to...