Assignment 4 – Managerial Accounting Focused: Answer questions 1 through 10 below using Microsoft Excel (input formulas where necessary) and show your work. Shingle Company manufactures and sells one product for $34 per unit. The company maintains no beginning or ending inventories and its relevant range of production is 20,000 units to 30,000 units. When Shingle produces and sells 25,000 units, its unit costs are as follows: Amount Per Unit Direct Materials $8.00 Direct Labor $5.00 Variable manufacturing overhead $1.00 Fixed manufacturing overhead $6.00 Fixed selling expense $3.50 Fixed administrative expense $2.50 Sales commissions $4.00 Variable administrative expense $1.00 Required: For financial accounting purposes, what is the total amount of product costs incurred to make 25,000 units? What is the total amount of period costs incurred to sell 25,000 units? If 24,000 units are produced, what is the variable manufacturing cost per unit produced? What is the average fixed manufacturing cost per unit produced? If 26,000 units are produced, what is the variable manufacturing cost per unit produced? What is the average fixed manufacturing cost per unit produced? If 27,000 units are produced, what are the total amounts of direct and indirect manufacturing costs incurred to support this level of production? What total incremental manufacturing cost will Shingle incur if it increases production from 25,000 to 25,001 units? What is Shingle’s contribution margin per unit? What is its contribution margin ratio? What is Shingle’s break-even point in unit sales? What is its break-even point in dollar sales? How much will Shingle’s net operating income increase if it can grow production and sales from 25,000 units to 26,500 units? What is Shingle’s margin of safety at a sales volume of 25,000 units? What is Shingle’s degree of operating leverage at a sales volume of 25,000 units?
Assignment 4 –
Answer questions 1 through 10 below using Microsoft Excel (input formulas where necessary) and show your work.
Shingle Company manufactures and sells one product for $34 per unit. The company maintains no beginning or ending inventories and its relevant range of production is 20,000 units to 30,000 units. When Shingle produces and sells 25,000 units, its unit costs are as follows:
|
Amount Per Unit |
Direct Materials |
$8.00 |
Direct Labor |
$5.00 |
Variable manufacturing |
$1.00 |
Fixed manufacturing overhead |
$6.00 |
Fixed selling expense |
$3.50 |
Fixed administrative expense |
$2.50 |
Sales commissions |
$4.00 |
Variable administrative expense |
$1.00 |
Required:
- For financial accounting purposes, what is the total amount of product costs incurred to make 25,000 units? What is the total amount of period costs incurred to sell 25,000 units?
- If 24,000 units are produced, what is the variable manufacturing cost per unit produced? What is the average fixed manufacturing cost per unit produced?
- If 26,000 units are produced, what is the variable manufacturing cost per unit produced? What is the average fixed manufacturing cost per unit produced?
- If 27,000 units are produced, what are the total amounts of direct and indirect
manufacturing costs incurred to support this level of production? - What total incremental manufacturing cost will Shingle incur if it increases production from 25,000 to 25,001 units?
- What is Shingle’s contribution margin per unit? What is its contribution margin ratio?
- What is Shingle’s break-even point in unit sales? What is its break-even point in dollar sales?
- How much will Shingle’s net operating income increase if it can grow production and sales from 25,000 units to 26,500 units?
- What is Shingle’s margin of safety at a sales volume of 25,000 units?
- What is Shingle’s degree of operating leverage at a sales volume of 25,000 units?
Since you have posted a question with multiple sub-parts, we will solve the first three subparts for you. To get the remaining sub-parts solved, please repost the complete question and mention the sub-parts to be solved.
Period costs are the sum total of all expenses which are not directly linked with the production process. In contrast to it, manufacturing costs or period cost is the expenses that are directly related to production.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images