ACCT 3224 | Winter 2022

Budgeting Assignment

!!!!!!please i need help on how to do this question, i am so lost and confused. your help will be very much aprechiated and i will put in good rateing.

Googly Ltd. is a company that manufactures and sells a single product called Huggle. For planning and control purposes they utilize a monthly master budget, which is developed in advance of the budget year. Their fiscal year end is September 30.

The sales forecast consisted of these few lines:

For the year ended September 30, 2021: 540,000 units at $21.00 each*

For the year ended September 30, 2022: 555,000 units at $22.00 each

For the year ended September 30, 2023: 570,000 units at $22.50 each

*Sales for the year ended September 30, 2021 are based on actual sales to date and budgeted sales for the duration of the year.

Your investigations of the companys records have revealed the following information:

1. Peak months for sales correspond with gift-giving holidays. History shows that January, March, May and June are the slowest months with only 4% of sales for each month. Sales pick up over the summer with July, August and September each contributing 6% to the total. Valentines Day in February boosts sales to 8%, and Easter in April accounts for 10%. As Christmas shopping picks up momentum, winter sales start at 12% in October, move to 16% in November and then peak at 20% in December. This pattern of sales is not expected to change in the next two years.

2. Sales are on a cash and credit basis, with 55% collected during the month of the sale, 30% the following month, and 13% the month thereafter, with 2% of sales considered uncollectible (bad debt expense).

3. From previous experience, management has determined that an ending inventory equal to 30% of the next months sales is required to fit the buyers demands.

4. Because sales are seasonal, Googly must rent an additional warehouse from October to December to house the additional inventory on hand. The only related cost is a flat $15,000 per month, payable at the beginning of the month.

5. There is only one type of raw material used in the production of Huggle: Huggle Acrylic (HA) is a very compact material that is purchased in powder form. Each Huggle requires 0.5 kilogram of HA, at a cost of $15.00 per kilogram. The supplier of HA tends to be somewhat erratic so Googly finds it necessary to maintain an inventory balance equal to 40% of the following months production needs as a precaution against stock-outs.

6. Googly pays for 40% of a months purchases in the month of purchase, 35% in the following month and the remaining 25% two months after the month of purchase. There is no early payment discount.

7. Beginning accounts payable will consist of $315,496 arising from the following estimated direct material purchases for August and September of 2021:

HA purchases in August, 2021: $273,780

HA purchases in September, 2021 $411,750

8. Googlys manufacturing process is highly automated, so their direct labour cost is low. Employees are paid at an average rate of $20.00 per hour. This rate already includes the employers portion of employee benefits. All payroll costs are paid in the period in which they are incurred. Each unit spends a total of 6 minutes in production. However, due to the fluctuations in actual sales, the company maintains a workforce of 30 full-time employees who are guaranteed a minimum of 160 hours each. During months in which production is low, these workers perform other tasks. In months when additional workers are needed, Googly hires temporary workers at $20 per hour. For simplicity, include all labour costs in the labour budget.

9. Variable manufacturing overhead is allocated based on units produced. The unit variable overhead manufacturing rate is $4.00

10. The fixed manufacturing overhead costs for the entire year is estimated to be $879,000, including depreciation of manufacturing equipment, $132,000. Fixed manufacturing overhead costs are incurred evenly over the year and paid as incurred. Googly uses the straight-line method of depreciation.

11. Selling and administrative expenses are largely fixed, and are estimated to be $912,000 for the year. These costs are paid in the month in which they occur, with the exception of the only non-cash item: a monthly depreciation of office equipment in the amount of $4,500. Starting in fiscal 2022, Googly intends to pay salespeople a commission of $0.75 per unit sold. This cost is not included in the estimate above, nor are bad debt expense (see point 2) or warehouse rental (see point 4).

12. Sales in August and September 2021 are expected to be $680,400 each month. Based on the above collection pattern this will result in Accounts Receivable of $381,024 at September 30, 2021, which will be collected in October and November 2021.

13. During the fiscal year ended September 30, 2022 Googly will be required to make monthly income tax installment payments of $45,000. Outstanding income taxes from the year ended September 30, 2021 must be paid in December 2021. Income taxes for the year ended September 30, 2022, in excess of installment payments, will be paid in December 2022.

14. Prior to the busy season, Googly is planning to purchase new manufacturing equipment for which they will need to pay cash. The bid that was accepted totaled $960,000 which will be paid in 8 equal instalments beginning in October 2021. Manufacturing overhead costs above already include the depreciation on this equipment.

15. An arrangement has been made with the local bank that if Googly maintains a minimum balance of $40,000 in their bank account, they will be given a line of credit at a preferred rate of 4.8% per annum (i.e., 0.4% per month). All borrowing is considered to happen on the first day of the month, repayments are on the last day of the month. All borrowings and repayments from the bank should be in multiples of $1,000 and interest must be paid at the end of each month. Interest is calculated on the balance at the beginning of the month, which includes any amounts borrowed that month (i.e., any borrowing for a month must occur at the beginning of that month). Googly has a loan balance of $323,000 at September 30, 2021.

15. Googly has a policy of paying dividends at the end of each month. The President tells you that the board of directors plans to continue their policy of declaring dividends of $25,000 per month.

16. A listing of the estimated balances in the companys ledger accounts as of September 30, 2021 is given below:

Cash $40,447 Accounts payable $ 315,496

Accounts receivable 381,024 Loan 323,000

Inventory-raw materials 219,780 Income tax payable 148,600

Inventory-finished goods 250,749 Capital stock 500,000

Capital assets (net) 2,252,600 Retained earnings 1,857,504

$3,144,600 $3,144,600

Required:

Prepare a monthly master budget for Googly for the year ended September 30, 2022, including the following schedules:

Sales Budget & Schedule of Cash Receipts

Production Budget

Direct Materials Budget & Schedule of Cash Disbursements

Direct Labour Budget

Manufacturing Overhead Budget

Selling and Administrative Expense Budget

Cash Budget