Question
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: 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. Monthly selling data for each product line can be found here:
Monthly Sales | Product Line | Units |
Jan-20 | Binders | 27 |
Jan-20 | Pens | 83 |
Jan-20 | Desks | 94 |
Jan-20 | Pencils | 95 |
Feb-20 | Desks | 11 |
Feb-20 | Binders | 15 |
Feb-20 | Pencils | 36 |
Feb-20 | Pens | 81 |
Mar-20 | Desks | 4 |
Mar-20 | Binders | 16 |
Mar-20 | Pencils | 56 |
Mar-20 | Pens | 99 |
Apr-20 | Desks | 11 |
Apr-20 | Binders | 22 |
Apr-20 | Pencils | 66 |
Apr-20 | Pens | 105 |
May-20 | Desks | 10 |
May-20 | Binders | 14 |
May-20 | Pencils | 75 |
May-20 | Pens | 105 |
Jun-20 | Desks | 4 |
Jun-20 | Binders | 15 |
Jun-20 | Pens | 76 |
Jun-20 | Pencils | 90 |
Jul-20 | Desks | 7 |
Jul-20 | Binders | 19 |
Jul-20 | Pencils | 53 |
Jul-20 | Pens | 101 |
Aug-20 | Desks | 13 |
Aug-20 | Binders | 24 |
Aug-20 | Pencils | 32 |
Aug-20 | Pens | 108 |
Sep-20 | Desks | 3 |
Sep-20 | Binders | 10 |
Sep-20 | Pencils | 90 |
Sep-20 | Pens | 93 |
Oct-20 | Desks | 8 |
Oct-20 | Binders | 11 |
Oct-20 | Pencils | 35 |
Oct-20 | Pens | 101 |
Nov-20 | Desks | 7 |
Nov-20 | Binders | 28 |
Nov-20 | Pencils | 67 |
Nov-20 | Pens | 73 |
Dec-20 | Desks | 8 |
Dec-20 | Pencils | 14 |
Dec-20 | Binders | 25 |
Dec-20 | Pens | 101 |
Given the sales overall data for the year in the Excel file you were provided, what was the operating income for Devos Inc in 2020?
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