Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

could you please help me Twin Mesa Corporation Economic Sensitivity Analysis Bad 11,500 Normal 13,000 Good 15,500 4 Economic Condition 5 Units of Production 6

could you please help me image text in transcribed
image text in transcribed
Twin Mesa Corporation Economic Sensitivity Analysis Bad 11,500 Normal 13,000 Good 15,500 4 Economic Condition 5 Units of Production 6 Sales 7 Direct Material 8 Direct Labor 9 Variable Support 10 Foxed Support 11 Variable Gen & Admin 12 Fixed Gen and & Admin 13 Total Expenses 14 Profit 10,000 10,000 5,000 10,000 5.000 5.000 16 Sales Price 17 Material Price 18 Labor Rate 19 Labor por Product 20 Overhead per Labor Hour 21 Gen & Admin per Labor Hour $20.50 $5.10 $8.55 $19.50 $4.95 $8.40 1.25 $0.50 $0.25 $20.00 $5.00 $8.50 1.25 $0.50 $0.25 88 IS Aa BbCcDdEe DEE = = . = AaBbccddee AaBbCcDc AaBbcode AaBbc A Heading 1 Heading 2 es, and improvements, choose Check for Updates. Scenario: Twin Mesa Corporation believes the economy could significantly affect the profitability of the company. During the next period, management suspects the economy could range from bad, in which they believe 11,500 units would be sold, to good, in which 15,500 units would be sold. The most likely scenario is that the economy would be normal and 13,000 units would be sold. The economy will also potentially affect the price of labor and material needed to produce the product. Goal: Determine expected profit under the conditions of a good, bad, and normal economy. B8 Procedure: 1. Enter formulas in the following cells: Cell Account Formula B6 Sales Sales Price X Units of Production B7 Direct Material Material Price X Units of Production Direct Labor Labor Hours per Product X Units of Production X Labor Rate B9 Variable Support Labor Hours per Product X Units of Production X Overhead per Labor Hour B11 Variable General and Labor Hours per Product X Units of Production Administrative X General and Administrative per Labor Hour B13 Total Expenses Sum of the amounts in B7:B12 B14 Profit Sales - Total Expenses 2. Using the Fill Right command, copy the formula to the following colls: From To B6 C6:06 B7 C7:07 B8 CBDB B9C9:09 B11 C11:011 B13 C13:013 B14 C14:14

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions