Question: Contribution Income Statements Using Excel; Sensitivity Analysis; Goal Seek Input Data: Per-Unit 2010 2011 Fixed mfg costs $40,000 $40,000 Fixed selling costs $20,000 $20,000 Revenue

Contribution Income Statements Using Excel; Sensitivity Analysis; Goal Seek

Input Data:	Per-Unit	2010	2011
Fixed mfg costs		$40,000	$40,000
Fixed selling costs		$20,000	$20,000
Revenue	$75.00
Variable mfg cost	$30.00
Var Selling costs	$5.00
Planned production		2,400	2,600
Planned sales		2,400	2,600

Required

1. Using the data in Exhibit 9.1, create an Excel spreadsheet to provide a sensitivity analysis of the effect on operating profit of potential changes in demand for HFI, Inc. Use Exhibits 9.2 and 9.6 as a guide.

2. Use the Goal Seek tool within Excel to determine which sales price would allow HFI to earn $100,000 operating profit, assuming that all the other cost information is the same as in Exhibit 9.1. Use Exhibit 9.5 as a guide.

Step by Step Solution

★★★★★

3.34 Rating (172 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Contribution Income Statements 1 A variety of possible spreadsheets could satisfy this requirement Once example is shown below The sensitivity analysi... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

249-B-M-L-P (344).xlsx

300 KBs Excel File

Students Have Also Explored These Related Management Leadership Questions!

Create an Excel spreadsheet to produce a chart similar to Figure 11.5 showing samples from a bivariate Students t-distribution with four degrees of freedom where the correlation is 0.5. Next suppose...

Why is Amazon able to provide a large variety of books and music with less safety inventory than a bookstore chain selling through retail stores?

Create an Excel spreadsheet to record, in proper form, the journal entries for each of the following events and transactions. a. Purchased, on open account, 4,000 pounds of direct materials at a...

Exercise 9-34 (Algo) Contribution Income Statements Using Excel: Sensitivity Analysis: Goal Seek [LO 9- 3,9-5) Required: 1. Using the data from 2022 in Geming Table Cost Date create an Excel...

Hello please help me work on the following assignments. I need them on monday ACCT 3331 Topics to know for Exam I Chapter 1 & 2 - Financial Accounting Standards and Conceptual Framework Know the...

Hello, Can you help me with this assignment? the instruction for this assignment is in the attachment below CIS 1220 Final Exam Problem Statement Fashion Impressions is a designer clothing...

125(3) Q1. If sales are $820,000, variable costs are 68% of sales, and operating income is $260,000, what is the contribution margin ratio? a. 53% b. 38% c. 47% d. 32% Q2. Which of the following...

6 points D References Required: 1. Using the 20X1 data in the Gaming Table Cost Data tab, create an Excel spreadsheet to provide a sensitivity analysis of the effect on operating profit of potential...

Classify each of the following expenditures as capital expenditure (CAP) or revenue expenditure (REV): .......... a. Purchase price .......... b. Ordinary recurring repairs to keep the machinery in...

If the government places a $500 tax on luxury cars, will the price paid by consumers rise by more than $500, less than $500, or exactly $500? Explain.

Compare zero - , one - , two - , and three - address machines by writing programs to compute G = ( A x B C x D ) / ( A + B x C - D ) for each of the four machines. Assume that A , B , C , and D above...

What are the primary approaches to valuing real estate?

If asked to assess a department's training needs how would you go about it?

Define internal politics.

Explain the role organizational structure can play in promoting internal politics.

Please help me with all parts (a,b,c,d) Finding operating and free cash flows Consider the balance sheets and selected data from the income statement of Keith Corporation that follow a. Calculate the...

"Boy, this is all so confusing," said Ryan as he stared at the papers on his desk. If only I had taken the advice of my finance instructor, I would not be in such a predicament today." Ryan Daniels,...

Income Statement Sales Cost of goods sold Gross profit Fixed expenses Depreciation EBIT 2021 9,500 (3.400) 6,100 (3.100) (1,600) 1,400 2020 8,900 (3.500) 5,400 (2,100) (1,600) 1,700 2020 650 2021 740...