ACCT 225 - Managerial Accounting Case Assignment 2 Part 2: Budgeting (24 marks) The Penticton Region was so happy with the expertise that you provided to them last year that they have Below is the information that they have provided respecting their sales forecast for the upcoming fiscal year: Budgeted sales (units) Budgeted sales revenue Cash beginning Accounts Receivable Accounts Payable Beginning finished goods inventory (units) Desired ending finished goods inventory (units) Desired ending finished goods inventory Beginning raw material inventory (kg) Desired ending raw material inventory (kg) Desired ending raw material inventory Variable MOH rate per direct labour-hour Fixed manufacturing overhead (FMOH) 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 7,400 8,000 5,900 7.000 $444,000 $480,000 $354,000 $420,000 $18,800 $31,300 $15,100 $1,570 1,740 19% of next quarter's budgeted sales 3.450 3,180 19% of next quarter's budgeted sales $2.00 $163,900 $163,900 $163,900 $163,900 You have gathered the following information from management respecting operations. a) Cash and borrowings: Required minimum cash balance each period 11,000 The region has an open line of credit to support operational needs. All borrowing is done at the beginning of a month, and all repayments are made at the end of a month. Borrowings and repayments must be in multiples of $1,000. Annual interest rate is: 11% b) Interest is paid only at the time of principal repayment The Accounts receivable balance at the beginning of the 1st quarter is from sales made the previous month. The entire amount will be received in the 1st quarter. Typically, sales are 40% in cash and 60% on credit. Seventy percent (70%) of credit sales are collected in the quarter that the sale occurs. 30% is collected in the following quarter. c) d) e) 17 8) h) Each unit requires two (2) kilograms of raw material that costs $8 per kilogram. Management plans to pay for 65% of raw material purchases in the quarter acquired and 35% in the the previous quarter and will be paid in full in the first quarter. Each unit produced requires 1.2 direct labour-hours. The hourly rate budgeted is $22 per hour. Dynamadics expects to purchase and pay for new equipment in the 1st quarter at a price of $25,000. Management also plans to sell equipment that no longer supports operations in the 2nd quarter for a price of $100,000. There are no depreciation considerations for this equipment Annual depreciation included in fixed manufacturing overhead is $216,000 Monthly operating expenses incurred include: Salaries (see note 1 below) $12,000 Rent $5,000 Amortization or pre-paid insurance $1,200 Depreciation of office equipment (note 1) Due to timing of payroll for the first quarter, 2/3 of the 1st quarter salary costs will be paid in the first quarter, the remaining 1/3 will be paid the next quarter. There is no payable for salaries outstanding at the beginning of the first quarter and there will not be any salary payables at the end of the 2nd quarter. i) $1,500 Part 2, Question 1 (24 marks) Prepare the following budgets for the upcoming fiscal year. a) Production budget b) Direct material budget c) Schedule of cash disbursements for direct materials d) Labour budget e) Manufacturing overhead budget Cash budget for the 1st and 2nd quarter fround results to the nearest dollar) Round all results to nearest dollar and all units to whole unit A template has been created in Excel for your use if desired. However some budget information is missing. Be sure to input the missing information in the template. If you feel there are not enough rows for your entries, adjust the template as necessary