Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Your job is to create the following documents: Fixed Manufacturing Overhead Rate Total finished goods units produced Total fixed overhead Fixed manufacturing overhead rate Ending
Your job is to create the following documents:
Fixed Manufacturing Overhead Rate
Total finished goods units produced
Total fixed overhead
Fixed manufacturing overhead rate
Ending Finished Good Inventory-Absorption
Direct Material
Direct Labor
Variable Overhead
Fixed Overhead
Total product cost per unit manufactured
Units in ending finished goods inventory
Ending Finished Goods Inventory-Variable
Direct material
Direct labor
Variable overhead
Variable cost per unit manufactured
Units in ending finished goods inventory
Diesel Dynamo Company | ||||||
Budget Project | ||||||
Fall 2017 | ||||||
INPUT SECTION | ||||||
SALES | ||||||
4th | 1st | 2nd | 3rd | 4th | ||
Quarter | Quarter | Quarter | Quarter | Quarter | ||
2017 | 2018 | 2018 | 2018 | 2018 | ||
Budgeted Sales in units | 43,000 | 37,900 | 34,500 | 31,000 | 43,000 | |
Budgeted Selling Price | $530 | per production unit (Finished Good) | ||||
RECEIVABLES | ||||||
Receivables Collection Schedule | 91.50% | quarter of sale | ||||
5.50% | quarter following sale | |||||
3.00% | uncollectible | |||||
100.00% | ||||||
Policy | Entire projected uncollectible receivables are written off each quarter | |||||
INVENTORY COSTS | ||||||
Direct Labor | 4.5 | hours | ||||
$19.50 | per direct labor hour | |||||
Raw Materials | 3 | direct material units per finished good production unit | ||||
$85.00 | per raw material unit | |||||
Variable Overhead | $9.50 | per Direct Labor Hour | ||||
Fixed Overhead | ||||||
Depreciation | $304,000 | per quarter | ||||
Other Fixed Overhead | $950,000 | per quarter | ||||
Fixed Overhead Application Rate | CALCULATE FROM PRODUCTION BUDGET | |||||
INVENTORY ACCOUNTS | ||||||
4th | 1st | 2nd | 3rd | 4th | ||
Ending Finished Goods Inventory | Quarter | Quarter | Quarter | Quarter | Quarter | |
in units | 0 | 15,000 | 19,000 | 20,000 | 15,000 | |
Raw Materials Inventory | ||||||
Beginning Inventory 1/1/2018 | 28,436 | units |
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