Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started