Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Before you market the product, you decide to create a spreadsheet to estimate the revenues, costs, profits and Breakeven Point. Go to the Bus 1011

Before you market the product, you decide to create a spreadsheet to estimate the revenues, costs, profits and "Breakeven Point." Go to the "Bus 1011 Excel Student Spreadsheets" and click on the tab/worksheet labeled "Breakeven Analysis." Enter the following data: In B3 type 10000 units sold. In B4 type $42 per unit sales price. In B5 enter the formula "=B3*B4" to calculate the revenue. In B7 type $11,500 in fixed costs. In B8 type 15 as the variable costs associated with making each unit. In B10 enter the formula "=B7+B8*B3" which is the fixed costs plus the $15 for each unit multiplied by the total number of units sold 10000. In B12 enter the formula "=B5-B10" to calculate the profits as revenues - costs. B14 calculates the Breakeven Point, which is FIXED COSTS/ (PRICE - VARIABLE COSTS). Enter the formula "=B7/(B4-B8)" Note that the Breakeven Point is in units and should therefore be rounded. You should set up the spreadsheet with the appropriate formulas to change the price, cost and sales volume quickly. Answer the following questions: 1. What are your revenues, total expenses and profit if you sell 10,000 Striders? 2. What are your revenues, expenses and profit if you sell 15,000 Striders by lowering the price to $35 each? 16 3. How many Striders do you need to sell at $42 to make $500,000 in profits? (Find the answer by entering different numbers in the appropriate Cell until you get the desired result) 4. How many Striders do you need to sell at $42 to break even?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Managerial Accounting For Dummies

Authors: Mark P Holtzman, Karen Schoenebeck

1st Edition

1118116429, 978-1118116425

More Books

Students also viewed these Accounting questions

Question

BR 1 5 " . : ! countNum . 2 1 Blastoff! - 3 ! 3 2 1 ! C + + "

Answered: 1 week ago