Question: Help me create an Excel spreadsheet using these information NOTE - Must set up input table for multiplying and link to appropriate earlier budget. Variable
Help me create an Excel spreadsheet using these information
NOTE Must set up input table for multiplying and link to appropriate earlier budget.
Variable Overhead
Purchasing and materials handling
Machine depreciation
Utilities and inspection
General manufacturing overhead
Fixed Overhead
Property taxes on plant
Building SL depreciation plant
Activity Based Budget Rates
$ per each pound of sheet metal & bar stock purchased $ per housing produced add all three types
$ per housing produced add all three types
$ per direct labor hour
Annual Cost
$
$
Administrative and Marketing Expenses:
NOTE Must set up input table for multiplying and link to appropriate earlier budget.
Variable Administrative and Marketing
Sales commissions
Shipping
Advertising
Fixed Administrative and Marketing
Property taxes on office
Building SL depreciation office
Administrative and marketing salaries
Activity Based Budget Rates
of total sales dollars
$ per housing shipped to customers add all three types
of total sales dollars
Annual Cost
$
$
$
Other Income and Expenses:
Interest Expense $
Interest Revenue $
Income tax rate
The company uses a FIFO cost flow assumption.
Required:
Prepare the following budgets for Y
All budgets must link to others so that a 'whatif scenario change will result in a correctly updated operating budget.
a Sales budget
b Production budget
c Direct materials budget
d Direct labor budget
e Manufacturing overhead budget
f Cost of goods sold budget
g Adminstrative and marketing expense budget
h Budgeted income statement
Checkpoint: Net Income
$
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
