CamDrone Manufacturing Overhead Budget For the year ended December 31, 2020 January Feburary March April May June Production in Units July August September October 103 170 November Variable overhead rate per unit 180.25 180.25 170 December Year 383 1,084 1,211 A HA HA HA 180.25 180.25 180.25 978 701 361 786 1,254 180.25 Variable manufacturing overhead 18.476 $ 30.643 30.643 $ $ 68.946 $ 180.25 $ 180.25 $ 180.25 1,275 218.328 $ $ 180.25 $ 180.25 180.25 195,346 126.400 65.115 $ Fixed manufacturing overhead: 176.194 141.722 225.988 $ 229.819 Supervisor Salaries Amortization of Plant & Equipment Insurance Training and Development Property and Business Taxes Other Total fixed manufacturing OH Total manufacturing OH Less: Amortization of Plant & Equipment * Less: Prepaid Insurance ** Less: Prepaid Property and Business Taxes ** Cash disbursements for manufacturing OH $ * Amortization is a non-cash expense ** Prepaid expenses addressed as separate line items in Cash BudgetManufacturing Costs and Inventory 3. Each camera drones spends a total of 6.75 hours in production. 4. Due to the highly technical nature of CamDrone's manufacturing process, CamDrone's direct labour rate has averaged $36.00 per hour for 2019. This rate already includes the employer's portion of employee benefits. A new collective agreement is being negotiated, with a 3% pay increase anticipated effective January 1, 2020. 5. Each CamDrone requires 1.55kg of direct materials. During 2019, the average cost of direct materials was $61/kg. The supplier of the direct materials tends to be somewhat erratic, so CamDrone finds it necessary to maintain a direct materials inventory balance equal to 40% of the following month's production needs as a precaution against stock-outs. 6. Due to the similarity of the equipment in each of the production stages and the company's concentration on a single product, manufacturing overhead is allocated based on volume (i .e. the units produced). The variable manufacturing overhead rate for 2019 is $175/unit, consisting of: Plant & Equipment Maintenance $73 Utilities 45 Indirect Materials 37 Other m $115 7. The fixed manufacturing overhead costs for 2019 are as follows: Supervisor's salary $ 181,800 Amortization of Plant & Equipment 132,000 Insurance 84,000 Training & Development 54,750 Property and Business Taxes 48,000 Other 30,000 Elig Amortization is calculated using the straightline method, with no amortization calculated in the year capital assets are acquired. 8. Aside from amortization, all other manufacturing costs are expected to increase by 3% in 2020 due to ination. 9. From previous experience, management has determined that an ending finished goods inventory equal to 25% of the next month's sales is required to efficiently meet customer demands. Collections Pattern 10. Sales are on a cash and credit basis, with 49% collected during the month of the sale, 33% the following month, and 15% the month thereafter. There are no early payment discounts for customers. Bad debt expense (amounts considered uncollectible) account for 3% of sales. 11. Based on the collection pattern described above, accounts payable as at end of business day on December 31, 2019 is projected to be $1,098,899 arising from the following estimates: Sales (November 2019) $1,170,000 Sales (December 2019) 1,800,000 Payments Pattern 12. CamDrone pays for 20% of a month's purchases of direct materials in the month of purchase, 50% in the following month and the remaining 30% two months after the month of purchase. There are no early payment discounts offered by suppliers. 13. Based on the payment pattern described above, accounts payable as at end of business day on December 31, 2019 is projected to be $78,641 arising from the following estimates: Direct Material Purchases (November 2019) $95,888 Direct Material Purchases (December 2019) 62,334 14. All payroll costs are paid in the period in which they are incurred. 15. The property and business taxes, paid at the beginning of July each year, apply to the following 12-month period. Any increases for ination on property and business taxes do not take effect until the beginning of July each year. 16. Annual insurance premiums, paid at the beginning of April each year, apply to the following 12-month period. Any increases for ination on insurance premiums do not take effect until the beginning of April each year. 17. Fixed manufacturing overhead costs are incurred evenly over the year and \"cash related\" amounts are paid as incurred. 18. Selling and administrative expenses are paid in the month in which they occur. Other 19. Anticipating a significant increase in customer demand and market share over the next few years, CamDrone is planning a signicant expansion involving acquiring additional manufacturing equipment for $3,000,000 cash. Half of this amount is to be paid to the equipment supplier in July 2020, with the remainder to be paid in October 2020. 20. Selling and administrative expenses are known to be a mixed cost; however, there is a lot of uncertainty about the portion that is fixed. Based on prior year experience: Lowest level of monthly sales: 80 units Total Operating Expenses: $87,270* Highest level of monthly sales: 1,600 units Total Operating Expenses: $360,780* * excluding bad debts and amounts described below These expenses are expected to increase by 3% in 2020 due to inflation. 21. To secure and grow its market share, CamDrone is planning to operate \"pop-up\" kiosks in various local retail centers during peak sales months (May-Aug, Nov-Dec) commencing Nov2019. CamDrone is budgeting $10,900 per month (including all related fees and taxes), payable at the beginning of each month, to set-up and operate these kiosks. The cost to set-up and operate \"pop-up\" kiosks will be in addition to the normal selling and administrative expenses described above and is not expected to increase during 2020. 22. Income tax expense is estimated to be 25% of net income. CamDrone makes monthly income tax installment payments of $250 and pays all outstanding income taxes (in excess of installment payments) in March of the following year. As such, any outstanding income tax balance for the year ended December 31, 2019 it will be paid in March 2020. 23. An arrangement has been made with the local bank that if CamDrone maintains a minimum balance of $50,000 in their bank account, they will be given a line of credit at a preferred rate of 3% per annum (0.25% 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 $10,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. 24. CamDrone has a policy of paying dividends at the end of each quarter. The President tells you that the Board of Directors is planning on declaring dividends as follows: March 2020 $125,000 June 2020 175,000 Se tember 2020 325,000 December 2020 325,000 Dividends are paid in the month they are declared