Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Devos Inc. sells bulk stationery supplies to businesses in El Paso. They have 4 product lines. Binders, Pencils, Pens, and Desks. Each of the Units

image text in transcribedimage text in transcribedimage text in transcribed

Devos Inc. sells bulk stationery supplies to businesses in El Paso. They have 4 product lines. Binders, Pencils, Pens, and Desks. Each of the Units represents one bulk order for a given product line. The selling price for each bulk unit is as follows: Item Price Binder $25 Desk 100 Pencil 8 Pens 12 The cost of goods sold for each bulk order is as follows: Item COGS Binder $ 12 Desk 40 Pencil 3 Pens 4 Their total variable selling expenses are estimated to be $10,000 for the year and are assigned proportionally to each product line based on its sales mix. Fixed costs for the year are estimated to be $6,800. (note: this is different from your practical application Ch. 3 homework where you were given monthly fixed costs and extrapolate that to yearly fixed costs. Here, you are given yearly fixed costs and you need to solve for BE or Target profit at a yearly amount so this number does not have to be transformed.) Monthly selling data for each product line can be found here: Analytical Project 1 Data for Students.xlsx For any answer that is a $ amount, do not include the $ in your input box. For any answer that is a %, do not include the % in your input box. Units 27 83 95 11 15 36 81 4 16 56 11 66 105 10 14 75 105 Monthly Sales Product Line Jan 20 Binders Jan 20 Pens Jan 20 Desks Jan 20 Pencils Feb 20 Desks Feb 20 Binders Feb 20 Pencils Feb 20 Penis Mar 20 Desks Mar 20 Binders Mar 20 Pencils Mar 20 Pens Apr 20 Desks Apr 20 Binders Apr 20 Pencils Apr 20 Pens May 20 Desks May 20 Binders May 20 Pencils May 20 Pens Jun 20 Desks Jun 20 Binders Jun 20 Pens Jun 20 Pencils Jul 20 Desks Jul 20 Binders Jul-20 Pencils Jul 20 Pens Aug 20 Desks Aur 20 Binders Aug 20 Pencils Aug 20 Pens Sep 20 Desks Sep 20 Binders Sep 20 Pencils Sep 20 Pens Oct 20 Desks Oct 20 Binders Oct 20 Pencils Oct 20 Pers Nov 20 Desks Nov 20 Binders Nov 20 Pencils Nov 20 Pens Dec 20 Desks Dec 20 Pencils Dec 20 Binders Dec 20 Pers 15 75 90 19 101 13 32 105 3 10 11 35 101 7 28 73 8 14 25 101 You calculated the operating income given the data you were provided in the Excel spreadsheet along with the original information you were given for Question 3. At that operating income, what is the margin of safety in sales dollars? Use information from prior rounding to get your correct answer. Round your final answer to the nearest dollar

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

Financial Accounting

Authors: Dr Carl S. Warren, Dr James M. Reeve, Philip E. Fess

9th Edition

032418803X, 978-0324188035

More Books

Students also viewed these Accounting questions

Question

a score of 60 or higher on the test?

Answered: 1 week ago