Aaaaaaaaaaaaaaaaaaaaaaaaaas

Assignments should be completed in groups of 3-4 students and must reflect the work of the group. Assignments submitted late will be assessed a 10% penalty per day \& will not be accepted 3 days after the due date. Assignments that are copied or prepared by other students, tutors or friends are considered a form of academic dishonesty \& will be assigned a grade of 0. The managers of Gizmo Manufacturing Limited have gathered the following information to assist you in preparing the master budget for the first quarter of 2024 . 1. Budgeted sales for the next four months are as follows: The selling price is $25.00 per unit. Sales are 100% on credit and 70% are collected in month of sale \& 30% in month following the sale. 2. Accounts receivable are expected to be $417,870 on December 31,2023 \& will be collected In January 2024. 3. The company produces enough units each month to meet the months sales plus a desired ending inventory equal to 20% of the next month's estimated sales. The beginning inventory at January 1,2024 is expected to be 10,000 units. 4. Gizmo pays 30% of direct materials in the month of purchase \& pays the remaining 70% in the following month. Each unit of product requires 5kg of direct materials at a cost of $1.50 per kg. The company purchases enough direct materials each month for the current month's production and 10% of next month's production requirements. Beginning \& ending inventory for the quarter of direct materials are budgeted to be 28,000 for beginning &26,000 for ending. 5. The Accounts payable balance is expected to be $146,200 at December 31,2023& will be paid in January. 6. The company plans to pays dividends of $15,000 in January \& March. 7. Gizmo Manufacturing Limited plans to purchase equipment costing $20,000 in February 8. Each unit produced requires .5 hours of direct labour at a cost of $20/ hour. 9. The company wishes to maintain a minimum cash balance of $25,000 at the end of each month. 10. The company has an agreement with the local bank that allows them to borrow up to $70,000. The interest rate on the loans is 8% and there are no loans outstanding at December 31 . All borrowing is done at the start of the month and all repayments are made at the end of the month. 11. The cash balance at December 31,2023 is budgeted to be $25,000. Required: 1. Using the excel file included in the assignment complete the following budgets for the first quarter of 2024 for Gizmo Manufacturing Limited (January, February \& March). Sales Budget \& Schedule of Expected Cash Collections Production Budget Direct Materials - Purchases \& Cash Disbursements Budget Direct Labour Budget Cash Budget 2. What will the accounts receivable \& accounts payable balances be at March 31, 2024? You may complete the assignment in excel or print out the template \& complete it by hand. SHOW ALL WORK - if necessary include a schedule showing you calculations. \begin{tabular}{|c|c|c|c|c|} \hline SCHEDULE OF & \multicolumn{4}{|c|}{ XPECTED CASH DISBUKSEMENTS FOF RAW MATERIALS } \\ \hline & January & February & March & Total \\ \hline \multirow{2}{*}{\multicolumn{5}{|c|}{ Accounts payable }} \\ \hline & & & & \\ \hline & & & & \\ \hline \multicolumn{5}{|l|}{ July purchases } \\ \hline \multicolumn{5}{|l|}{ August purchases } \\ \hline \multicolumn{5}{|l|}{ Spetember purchases } \\ \hline & & & & \\ \hline Total cash disbursements & & & & \\ \hline & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline & \multicolumn{2}{|c|}{ GIZMO \$LANUFACTUR|NG LIMITED } & & \\ \hline & \multicolumn{2}{|c|}{ SALES BUDGET } & & \\ \hline & January & February & March & Total \\ \hline \multirow{2}{*}{\multicolumn{5}{|c|}{ Sales in units }} \\ \hline & & & & \\ \hline & & & & \\ \hline \multicolumn{5}{|l|}{ Selling price per unit } \\ \hline & & & & \\ \hline \multicolumn{5}{|l|}{ Total budgeted sales } \\ \hline & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline & \multicolumn{2}{|c|}{ PRODUCTION BLDGET } & \multirow[b]{2}{*}{ March } & \multirow[b]{2}{*}{ Total } \\ \hline & January & February & & \\ \hline \multicolumn{5}{|l|}{ Budgeted sales in units } \\ \hline & & & & \\ \hline \multicolumn{5}{|l|}{ Desired ending inventory } \\ \hline \multirow{2}{*}{\multicolumn{5}{|c|}{ Total needs }} \\ \hline & & & & \\ \hline \multicolumn{5}{|l|}{ Beginning inventory } \\ \hline & & & & \\ \hline \multicolumn{5}{|l|}{ Required production (unit) } \\ \hline & & & & \\ \hline & & & & \\ \hline \end{tabular}