Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In order to determine the loan amount, your manager asks you to prepare the following budgets: sales budget, production budget, direct materials purchases budget, direct
In order to determine the loan amount, your manager asks you to prepare the following budgets:
sales budget,
production budget,
direct materials purchases budget,
direct labor budget, and
overhead budget.
Directions
Prepare each budget of this assignment in one Excel file. Be sure to show your calculations and label your work for full credit.
The Forty Company estimates for the next year are as follows:
Quarter sales: units
Quarter sales: units
Quarter sales: units
Quarter sales: units
Quarter of the following year sales: units
Price of the product $
Beginning finished goods inventory: units
The company policy is to have of next quarter's sales in ending inventory.
The product contains only two materials Material A and Material B
The product requires four units of Material A costing $
The product requires two units of Material B costing $
The beginning materials inventory for Material A is
The beginning materials inventory for Material B is
Company policy is to have of next quarter's material needs in ending inventory
Desired ending inventory for the year in Material A is
Desired ending inventory for Material B is
The direct labor required for each product is hours at an average rate of $ per hour.
The variable overhead rate is $ per direct labor hour.
Fixed overhead is expected to be $ per quarter.
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