Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What is the formula.[utilizing cells]? The following information applies to the products of Corbett Company. begin{tabular}{l|c|cc|} hline & Product A & Product B hline
What is the formula.[utilizing cells]?
The following information applies to the products of Corbett Company. \begin{tabular}{l|c|cc|} \hline & Product A & Product B \\ \hline Selling price per unit & $40.00 & $ & 32.00 \\ Variable cost per unit & $24.00 & $ & 12.00 \\ \hline \end{tabular} Identify the product that should be produced or sold under each of the following constraints. Consider each constraint separately. - One unit of Product A requires 2 hours of labor to produce, and one unit of Product B requires 4 hours of labor to produce. Due to labor constraints, demand is higher than the company's capacity to make both products. - The products are sold to the public in retail stores. The company has limited floor space and cannot stock as many products as it would like. Display space is available for only one of the two products. Expected sales of Product A and Product B are 8,000 units and 9,000 units, respectively. - The maximum number of machine hours available is 40,000 . Product A uses 2.50 machine hours, and Product B uses 4 machine hours. The company can sell all the products it produces. \begin{tabular}{|r|r|r|} \hline 2 & 4 & \\ \hline & & \\ 8,000 & 9,000 & \\ \hline 40,000 & 2.50 & 4 \\ \hline \end{tabular} Required Complete the spreadsheet. Required Complete the spreadsheet. \begin{tabular}{|c|c|c|c|c|c|c|} \hline & \multicolumn{2}{|c|}{ Product A } & \multicolumn{2}{|c|}{ Product B } & \multicolumn{2}{|l|}{\begin{tabular}{l} should be \\ produced \end{tabular}} \\ \hline Selling price per unit & $40.00 & & $32.00 & & & \\ \hline Variable cost per unit & $24.00 & & $12.00 & & & \\ \hline Contribution margin per unit & $16.00 & & $20.00 & & & \\ \hline Scarce resource is labor & 2 & hours & 42 & hours & & \\ \hline Contribution margin per labor hour & $8.00 & & $5.00 & & Product A & \\ \hline Scarce resource is floor space & 8,000 & units & 9,000 & units & & \\ \hline Total contribution margin & $128,000 & & $180,000 & & Product B & 2 \\ \hline Scarce resource is machine hours & 2.5 & hours & 4 & hours & & \\ \hline Contribution margin per machine hour & $6.40 & & $5.00 & & & \\ \hline Number of machine hours & 40,000 & & 40,000 & & & \\ \hline Total contribution margin & $640,000 & & $800,000 & & Product A & 2 \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started