Question
The focus of this project is to create a master budget for the Williams Company based on the companys industry outlook, recent company outcomes, and
The focus of this project is to create a master budget for the Williams Company based on the company’s industry outlook, recent company outcomes, and the company’s business rules. You will create a master budget for Williams Company, including their cash budget and the proforma financial statements.
Master Budget Project Details
This project is a master budgeting project using the Williams Company scenario presented below. Complete your master budget using the provided Excel spreadsheet template (i.e., Williams Company Template.xlsx) and submit the completed in this budget template using the submission link in this BBL folder.
The Williams Company manufactures PVC piping in long pipes which a finish manufacturer purchases and cuts to length for sale to retailers. Williams Company manufactures their piping using resin, sheets of raw PVC, and direct labor.
The Williams Company has the following balance sheet as of December 31st.
Balance Sheet on December 31st
Assets | ||
Cash | $41700 | |
Accounts Receivable | 192000 | |
Raw Materials | 102240 | |
Finished Goods | 64400 | |
Land | 50000 | |
Plant and Equipment | 500000 | |
Less: Accumulated Depreciation | 112000 | 388000 |
Total Assets | $838340 | |
Liabilities and Stockholders’ Equity | ||
Accounts Payable to Suppliers | $40000 | |
Common Stock | 100000 | |
Retained Earnings | 698340 | 798340 |
Total Liabilities and Equity | $838340 |
The information shown below is extracted from the records of the Williams Company.
The Williams Company has projected its unit sales for the next five months to be:
Month | Units |
January | 7000 |
February | 8000 |
March | 10000 |
April | 8000 |
May | 7000 |
All sales are made on accounts receivable. Each unit of PVC sells for $60. Forty percent of all sales are collected in the month of the sale. The remaining 60% of the sales are collected in the following month. May consider bad debts as non-existent.
Williams Company has a management rule that at the end of each month the ending finished goods inventory of PVC must be 20% of the following month’s forecasted sales. Williams Company’s finished goods inventory on December 31st consists of 1400 units of PVC piping.
In order to produce one unit of PVC pipe, the following units of raw PVC and resin are used.
Raw Material | Units |
Raw PVC | 5 |
Resin | 3 |
The price of raw PVC sheets is now $4.00 per unit. The price of resin is $2.80 per unit. Management desires to maintain ending raw materials inventories for raw PVC and resin at 25% of the next month’s production needs. William Company’s December 31st raw material holdings were 18,000 units of raw PVC (at $4.00 per unit) and 10,800 units of resin (at $2.80 per unit).
Seventy percent of all purchases (raw PVC and resin) are paid in the month of purchase. The remaining 30% is placed on an account payable and paid the following month.
The production of PVC by Williams Company requires 30 minutes of direct labor time to complete. All labor costs are paid in the month incurred. Each hour of direct labor costs Williams Company $24.
Factory overhead is applied at the rate of $12 per direct labor hour. Actual overhead costs are paid as they are incurred. Monthly differences between applied and actual overhead costs are expected to be negligible.
Selling and Administrative expenses are $10,000 per month plus 10% of sales. All these expenses are paid in the month in which they are incurred.
Plant and equipment depreciate at the rate of $12,000 per year. This depreciation is incurred evenly throughout the year and is included in the factory overhead costs mentioned earlier.
Step by Step Solution
3.50 Rating (157 Votes )
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