Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are a middle manager of Time For You, Inc., a manufacturer and seller of a variety of household products that make life easier. The

image text in transcribed
You are a middle manager of Time For You, Inc., a manufacturer and seller of a variety of household products that make life easier. The company is considering adding a model of hand-held car vacuum, which would be their first entry into offering this type of product. The manager assigned to evaluate this situation, Randy Connor, phones you to discuss various sspects of the venture. He does not understand much about cost behavior or cost-volumeprofit analysis, but has the following information to provide to you. Based on current competition, the suggested selling price is $36 per unit. The variable costs and expenses per unit are $16.50 with expected total fixed costs associated with the product to be $124,800 per year. The marketing department feels confident that the company can sell at least 7,000 units per year, with their current sales forecast of 7,750 units per year. Of course, the marketing people can sometimes be overly optimistic, so Randy is asking for your perspective. You promise to run some numbers and email him with your results. Create a spreadsheet with input cells containing the above information as well as an output section that: (a) provides forecasted profit within a contribution margin format income statement based on 7,750 units sold forecast (Be sure to use a heading and proper format so others using your report can understand what the amounts represent.) (b) provides a separate cell detailing the contribution margin per unit (with label) (c) provides a separate cell detailing the contribution margin ratio (with label) (d) provides a separate cell detailing breakeven point in units (with label) (e) provides a separate cell detailing breakeven point in dollars (with label) (f) provides a separate cell detailing margin of safety in units (with label) (g) provides a separate cell detailing margin of safety in dollars (with label)

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