Question
Question5. Create a traditional Income Statement assuming a volume of 1,800 units. For the cost of goods sold, please use the per unit cost you
Question5.
Create a traditional Income Statement assuming a volume of 1,800 units. For the cost of goods sold, please use the per unit cost you calculated in #2. You do not have to prepare any additional schedules. I would use a similar format to exhibit 16-8 on page 737 or from your lecture notes. I recommend that you list out all operating expenses (period costs) identified in Q1. Do not use just Selling and General/Administrative Expenses for your categories. Points will be lost by not listing out all period costs. You can ignore interest and income tax expense. These numbers should be linked toQ1
(Question 1. . Please identify and calculate totals for the following classifications on ALL costs listed on the first page: variable and fixed costs; product and period costs. The schedule should contain numbers for each area on a yearly basis. For the variable cost, also show them on a per unit basis. (must be calculated based on 1800 units above)
Play and Stay Manufacturing(P&S) has a factory that produces cabinetry for the RV and marine market. The company has other product lines. Materials and labor for the cabinets are determined by each job. To simplify the assignment, we will assume the following average costs The following information highlights P&S Manufacturing's cost structure for 2020.
The materials include $2,800 for the wood and other materials on a per job basis.
It requires 24 hours of labor on average for the cabinetry. The hourly rate is $11.
The sales price will be set at a markup of 80%.
The company estimates that it will have 43,200 direct labor hours in total for the cabinets.
It assumes 1800 units are sold on average per year.
A breakdown of estimated yearly costs related to the cabinetry follows:
Salaries- office & administrative $ 500,000
Salaries for factory personal $ 350,000
Office Rent $ 150,000
Factory Rent $ 30,000
Office utilities and Misc office expenses(based on units sold) $ 15,000
Sales travel(based on units sold) $ 24,000
Insurance - office $ 12,000
Depreciation - office equipment $ 40,000
Depreciation for factory equipment $ 70,000
Advertising $ 20,000
Sales commissions(based on units sold) $ 50,000
Factory Property taxes $ 25,000
Maintenance for factory equipment $ 80,000
General requirements: A schedule will be created for each of the following questions. Use a new worksheet (not workbook) to answer each question. You can combine Q6 and Q7 in one sheet for comparison purposes. All schedules should be included in excel. Your spreadsheets must contain formulas and referring numbers. Not using formulas will result in a minimum one letter-grade reduction. Linking the schedules is required. Your spreadsheet must be professional and include the following items: report titles, formatted numbers, single and double underlines, and correct spelling. Every number should be labeled clearly so the reader understands what numbers represent. If you are unsure about the format, please review the textbook for a similar report or ask!!!
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