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 S/L depreciation - plant
Activity Based Budget Rates
\(\$ 0.35\) per each pound of sheet metal \& bar stock purchased \(\$ 1.50\) per housing produced (add all three types)
\(\$ 2.50\) per housing produced (add all three types)
\$2.00 per direct labor hour
Annual Cost
\$175,000
\$127,500
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 S/L depreciation - office
Administrative and marketing salaries
Activity Based Budget Rates
7.5\% of total sales dollars
\(\$ 1.00\) per housing shipped to customers (add all three types)
2.0\% of total sales dollars
Annual Cost
\$55,000
\$32,000
\$192,000
Other Income and Expenses:
Interest Expense \$ 127,400.00
Interest Revenue \$ 30,550.00
Income tax rate 35\%
The company uses a FIFO cost flow assumption.
Required:
Prepare the following budgets for 20Y5.
All budgets must link to others so that a 'what-if' 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
\(\$ 25,878,726\)
Help me create an Excel spreadsheet using these

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!