Harold McWilliams owns and manages a general merchandise store in a rural area of Virginia. Harold sells appliances, clothing, auto parts, and farming equipment, among a wide variety of other types of merchandise. Because of normal seasonal and cyclical fluctuations in the local economy, he knows that his business will also have these fluctuations, and he is planning to use CVP analysis to help him understand how he can expect his profits to change with these fluctuations. Harold has the following information for his most recent year. Cost of goods sold represents the cost paid for the merchandise he sells, while operating costs represent rent, insurance, and salaries, which are entirely fixed. Sales $ 580,000 Cost of merchandise sold 359,600 Contribution margin 220,400 Operating costs 96,520 Operating profit $ 123,880 Required: 1-a. What is Harold’s margin of safety (MOS) in dollars? (Do not round intermediate calculations.) 1-b. What is the margin of safety (MOS) ratio?
(Input your answer as a percentage rounded to 2 decimal places (i.e., 0.1567 = 15.67%).) 3. What is Harold’s margin of safety (in dollars) and operating profit if sales should fall to $510,000? (Do not round intermediate calculations.)
Ans. 1a | Margin of safety = Operating profit / Contribution margin ratio | |||
$123,880 / 38% | ||||
$326,000 | ||||
Ans. 1b | Margin of safety ratio = Margin of safety / Sales * 100 | |||
$326,000 / $580,000 * 100 | ||||
56.21% | ||||
Ans. 3 | Margin of safety = Operating profit / Contribution margin ratio | |||
$97,280 / 38% | ||||
$256,000 | ||||
*Working Notes: | ||||
*Contribution margin ratio = Contribution margin / Sales * 100 | ||||
$220,400 / $580,000 * 100 | ||||
38.00% | ||||
*Calculations of Contribution margin if sales fall to $510,000 : | ||||
Contribution margin = Sales * Contribution margin ratio | ||||
$510,000 * 38% | ||||
$193,800 | ||||
*Calculations of Operating profit on this level is : | ||||
Contribution margin | $193,800 | |||
Less: Operating costs | -$96,520 | |||
Operating profit | $97,280 | |||
Harold McWilliams owns and manages a general merchandise store in a rural area of Virginia. Harold...
Harold McWilliams owns and manages a general merchandise store in a rural area of Virginia. Harold sells appliances, clothing, auto parts, and farming equipment, among a wide variety of other types of merchandise. Because of normal seasonal and cyclical fluctuations in the local economy, he knows that his business will also have these fluctuations, and he is planning to use CVP analysis to help him understand how he can expect his profits to change with these fluctuations. Harold has the...
Check my work Harold McWilliams owns and manages a general merchandise store in a rural area of Virginia. Harold sells appliances, clothing, auto parts, and farming equipment, among a wide variety of other types of merchandise. Because of normal seasonal and cyclical fluctuations in the local economy, he knows that his business will also have these fluctuations, and he is planning to use CVP analysis to help him understand how he can expect his profits to change with these fluctuations....
Harold McWilliams owns and manages a general merchandise store in a rural area of Virginia. Harold sells appliances, clothing, auto parts, and farming equipment, among a wide variety of other types of merchandise. Because of normal seasonal and cyclical fluctuations in the local economy, he knows that his business will also have these fluctuations, and he is planning to use CVP analysis to help him understand how he can expect his profits to change with these fluctuations. Harold has the...
Chapter 9 Assignment Saved Help Save & Exit Submit Check my work Harold McWilliams owns and manages a general merchandise store in a rural area of Virginia. Harold sells appliances, clothing, auto parts, and farming equipment, among a wide variety of other types of merchandise. Because of normal seasonal and cyclical fluctuations in the local economy, he knows that his business will also have these fluctuations, and he is planning to use CVP analysis to help him understand how he...
In June 2008, when gasoline prices were at an all-time high (more than $3.81 per gallon), Chrysler Motor Company promoted its Jeep vehicle with the offer of either $4,250 off the price of the vehicle or the guarantee that the buyer would not pay more than $2.75 per gallon of gas for the next 3 years (the details of the guarantee could vary by dealer). Required: 1. Assume that the Jeep vehicle you are interested in gets 15 mpg combined...
!!!PLEASE USE EXCEL SO I CAN
LEARN IT!!!
Mark Make-a-Buck sells jars of beach sand in Florida. His price per jar is $2.50. His historical costs have been: Jar Cap Label Sales commission to retailers Excavating machine depreciation Mark's salary (President) $.40 per item $.10 per item $.30 per item $.20 per item $500 per month $1,000 per month 1. a. What is Mark's breakeven point for the month, in terms of both quantity and sales dollars on a pretax...
CVP Modeling project Directions The purpose of this project is to give you experience creating a multiproduct profitability analysis that can be used to determine the effects of changing business conditions on the client's financial position. Your goal will be to use Excel in such a way that any changes to the assumptions will correctly ripple through the entire profitability analysis. You have been hired by Jake to build a CVP model that will help him understand the impact of...
PLEASE help! the paper are the instructions to fill in the
boxes in the excel sheet
eating a multiproduct profitability fthis project is to give the effects of changing business conditions on the The purposes can be used to deters will be to use Excel such a way that any changes to the Excel CVP Modeling project The purpose of this project is to give you experience creating a mi analysis that can be used to determine the effects of...
please explain how to get the sales revenue at breakeven and the
sales revenue at target profit (the gray boxes)! :)
131 Center $ . % Xv fx ) Conditional Format Forming as a St Launch Shipping and handling ---- 40.3951 94 11 1 523.4117647 se Wet Business & Directions Original Assumptions Advising client - on Ready Multiproduct Breakeven point: -in units Sales revenue at breakeven Product #1 53.78151261 Product #2 40.33613445 Total 94.11764706 + Product #1 Product #2 Multiproduct...