Week 6 Homework Assignment

profilemegan.mcwafe04s6
EMG4006ExampleofFourProformaBudgetsforChapter6-OperationsPlan.xlsx
Home>Business & Finance homework help>Management homework help>Week 6 Homework Assignment

Facilities Budget

Five Year Proforma Facilities and Facility Improvements Budget
Company:
Year: Existing 1 2 3 4 5
For Year ending Dec. 31,
Land
-
-
Buildings
-
-
Building Improvements
-
-
Services and Utilities Connection
-
-
Roads and Grounds Preparation
-
-
Grand Total Budget
Instructions:
Show the year in each column including the current year for the existing Facilities.
Describe details of each category of investment as line items (Land, Buildings, Building Improvements, Services and Utilities Connection
Fees, and Roads and Grounds Preparation/Landscaping).
Indicate the forecast gross value of investment for each line item described, timed as to the year in which the investment will occur.
In the "Existing" column indicate the value of any existing Facilities prior to the Expansion Plan.

Equipment Budget

Five Year Proforma Machinery and Equipment Budget
Company:
Year: Existing 1 2 3 4 5
Year ending Dec. 31,
Manufacturing Machinery
-
-
Manufacturing Tooling
-
-
Manufacturing General Equip
-
-
Office Eequpment
-
-
IT & Communications Equip
-
-
Grand Total Budget
Instructions:
Show the year in each column including the current year for the existing Equipment.
Describe details of each category of investment as line items (Manufacturing Machinery, Manufacturing Tooling, Manufacturing
General/Other, Office Equipment and IT/Communications Equipment).
Indicate the forecast gross value of investment for each line item described, timed as to the year in which the investment will occur.
In the "Existing" column indicate the value of any existing Equipment prior to the Expansion Plan.
You can modify the Description headings if they don't fit with your specific business.

Staffing Budget

Five Year Proforma Staffing Requirements and Cost Budget
Company:
Year: Actual 1 2 3 4 5
Year ending Dec. 31,
Operating Function No. of Staff Cost of Staff $ No. of Staff Cost of Staff $ No. of Staff Cost of Staff $ No. of Staff Cost of Staff $ No. of Staff Cost of Staff $ No. of Staff Cost of Staff $
R & D
Engineering
Purchasing
Receiving
Production Floor
Quality Control
Material Handling
Shipping
Customer Service
Administration
Total - All Functions
Instructions:
Show the year in each column including the current year for the existing Staffing.
Describe details of each category of operating function as applicable for your business.
Indicate the forecast number of staff members and their total annual cost for each line item, timed as to the year in which the staffing will occur.
In the "Existing" column indicate the number of staff members and their cost prior to the Expansion Plan.
You can modify the Operating Function headings if they don't fit with your specific business.
Carry forward the yearly total cost figures to the Operating Expense Budget in Section 6.6

Operating Expense Budget

Five Year Proforma Operating Expense and Working Capital Budget
Company:
Year: Actual 1 2 3 4 5
Year ending Dec. 31,
Variable Expenses
- Direct Material
- Manpower
- Marketing
- Other Variable Costs
Periodic Expenses
- Licence Renewals
- Insurance
- Other Periodic Costs
Fixed Expenses
- Management
- Utilities
- Fixed Marketing
- Other Fixed Costs
Other Expenses
-
-
Working Capital
- Cash Reserves
-
Grand Total Budget
Instructions:
You can add additional detail lines as needed to explain your business
In variable costs summarize the additional factory/office manpower costs that are detailed in Section 6.5 of Chapter 6
In variable costs, summarize marketing costs that are detailed in Chapter 4 Assume all Marketing Costs are Variable
In fixed costs summarize the senior management team costs detailed in Chapter 5
Time expenses by year for the five-year business plan period to reflect the expected growth from your expansion plan.
In the column headings, add the year to the current column headings e.g. Actual - 2020
In the "Actual" column indicate the value of the actual operating expenses incurred in the past 12 months, prior to the Expansion Plan.
Periodic Expenses are costs that occur periodically (quarterly, semi-annually or annually) instead of continuously.
Working Capital isn't an operating expense but represents cash that will be needed to fund operating losses, inventory, accounts receivable until the business is self supporting (i.e. positive change in cash position). The amount to be shown in Cash Reserves is the cash funding required to maintain a minimum targeted positive cash balance.