Question: Problem 3-53 (Algo) CVP Analysis-Sensitivity Analysis (spreadsheet recommended) (LO 3-1) Alameda Tile sells products to many people remodeling their homes and thinks that it

Problem 3-53 (Algo) CVP Analysis-Sensitivity Analysis (spreadsheet recommended) (LO 3-1) Alameda Tile sells products to many people remodeling their homes and thinks that it could profitably offer courses on tile installation, which might also increase the demand for its products. The basic installation course has the following (tentative) price and cost characteristics. Tuition Variable costs (tiles, supplies, and so on) Fixed costs (advertising, salaries, and so on) $ 420 per student 200 per student 101,200 per year Required: a. What enrollment will enable Alameda Tile to break even? b. How many students will enable Alameda Tile to make an operating profit of $63,800 for the year? c. Assume that the projected enrollment for the year is 830 students for each of the following (considered independently): 1. What will be the operating profit (for 830 students)? 2. What would be the operating profit if the tuition per student (that is, sales price) decreased by 7 percent? Increased by 25 percent? 3. What would be the operating profit if variable costs per student decreased by 14 percent? Increased by 18 percent? 4. Suppose that fixed costs for the year are 8 percent lower than projected, whereas variable costs per student are 9 percent higher than projected. What would be the operating profit for the year?

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 Accounting Questions!

Problem 3-53 (Algo) CVP Analysis-Sensitivity Analysis (spreadsheet recommended) (LO 3-1) Alameda Tile sells products to many people remodeling their homes and thinks that it could profitably offer...

Instructions: Complete the tables and questions below. Type your answers into this form, save it as a PDF and upload it to the Assignment on Canvas. NOTE: Sometimes students (MAC users, I think)...

3-42 CVP Analysis USE THE VALUE BELOW IN SOLVING THE PROBLEM Alameda Tile sells products to many people remodeling their homes and thinks that they could profitably offer courses on tile...

Analysis of Cost Structure: Foxx Company vs. Beyonce, Inc. Create an Excel worksheet to calculate the breakeven analysis for Foxx and Beyonce, Be sure to link the yellow output fields to the green...

CVP Analysis-Sensitivity Analysis (spreadsheet recommended) Alameda Tile sells products to many people remodeling their homes and thinks that they could profitably offer courses on tile installation,...

Recuired infermetion Problem-12-25 (Algo) CVP analytis-whot-if quections, breakeven LO 12-7, 12:-, 12-9, 12-10 Problem 12.25 (Algo) Port e Noteis seiect all that apply. Check Ail That mpgy Ae varabie...

Required information Problem 12-25 (Algo) CVP analysis-what-if questions; breakeven LO 12-7, 12-8, 12-9, 12-10 [The following information applies to the questions displayod below] Marathon Company...

Required information Problem 12-25 (Algo) CVP analysis-what-if questions; breakeven LO 12-7, 12-8, 12-9, 12-10 [The following information opplies to the questions dispiayed below] Marathon Compary...

Problem 6-20 (Algo) CVP Applications: Break-Even Analysis; Cost Structure; Target Sales [LO6-1, LO6-3, LOG-4, LO6-5, LOG-6, LOG-8] Northwood Company manufactures basketbalis. The company has a ball...

Required information Problem 12-25 (Algo) CVP analysis-what-if questions; breakeven LO 12-7, 12-8, 12-9, 12-10 [The following information applies to the questions displayed below.] Marathon Company...

The following transactions and events relate to the operation of a government hospital. a. Prepare journal entries to record the effects of these transactions and events in the general ledger...

Examine what happens to the gross profit margin when: a. Advertising is incurred. b. Selling prices are increased. c. Suppliers increase their prices.

Solve the system of differential equations. { ( x _ ( 1 ) ^ ( ' ) = 6 x _ ( 1 ) - 2 x _ ( 2 ) ) : } x _ ( 2 ) ^ ( ' ) = 2 x _ ( 1 ) + 1 0 x _ ( 2 ) x _ ( 1 ) ( 0 ) = 1 6 , x _ ( 2 ) ( 0 ) = - 1 6 x _...

Show that if x is a nonzero column vector in R n , then the n n matrix A= I n (2 /x 2 ).xx T is both orthogonal and symmetric.

Let A be a 3 3 matrix, each of whose entries is 1 or 0. What is the largest possible value for det (A)?

Post1. Would you prefer to have $100 today or $100 one year from now? Why? Post2. How can compound build wealth over time? Post3. How can compounding increase debt over time? Post4. Based on your...

Which of the following are considered Current assets? A. Cash, Buildings, Accounts Receivable. B. Cash, Accounts Payable, Inventory. C. Cash, Accounts Receivable, Inventory. D. Buildings, Land, Cash.

Construct an amortization schedule for a six-year, RM20,000 loan at 7% interest compounded annually a) If the first payment is made one year from now. b) If the first payment is made immediately.

Create a 200 word summary on the Juvenile Justice System than and today. Describe The Juvenile system and provide a generalizable definition. Highlight the issues in the Juvenile system and why this...

Jodie is a wholesaler of electrical discount goods. She buys in end-of-line and seconds quality stock from manufacturers and sells it on to small electrical retailers. She has to take advantage...

Why should I adopt a total quality management viewpoint?

Kerry owns the concession to run a souvenir shop at a tourist location near London. She sells souvenir tea towels, cards, biscuits, and various toys and gifts. Kerry's sales for the year to 30...