undefined
Units 27 83 95 11 15 35 81 16 56 99 11 22 66 105 10 75 105 4 15 Monthly Sales Product Line Jan 20 Binders Jan 20 Pers Jan 20 Desks Jan 20 Pencils Feb 20 Deses Feb 20 Binders Feb 20 Pencils Feb 20 Pens Mar 20 Deses Mar 20 Binders Mar 20 Pencils Mar 20 Pens Apr 20 Desks Apr 20 Binders Apr 20 Pencils Apr 20 Pens May 20 Deses 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 Aug 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 Pens Nov 20 Deses Nov 20 Binders Nov 20 Pencils Nov 20 Pens Dec 20 Desks Dec 20 Pencils Dec 20 Binders Dec 20 Pens 75 sal 7 19 53 101 13 24 32 105 3 10 90 93 8 11 35 101 7 28 67 73 8 14 25 101 Besides downloading the spreadsheet at the bottom of these instructions, make sure put the information you see in this window in your excel (e.g. the sales price and COGS per unit by product line, info on the total variable selling expense for the year, and the fixed costs for the year). You are given yearly data and you will need to answer in yearly data for all but 1 question. You do not need to convert any monthly costs to a yearly cost. 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. 0.5 points Save Answer What is the total amount of sales dollars Devos, Inc. would need to break even for all 4 product lines combined? (Hint: Use the rounded quantities from your answer in Question 1 for each product line to calculate the total sales dollars for all 4 product lines combined to break even.)
