please do it in detail thank you

heres the worksheet template

HAL MANALAINEN EUR PROBLEM QUESTION BUDGET MOOPINKY Berhad is a company specialising in the production of organic cleansers that are exported to Singapore. The company usually prepares its operating and financial budgets on a quarterly basis. The following operational information were projected for 2021/2022: Direct material (organic mixture) required per bottle (in ml) SO Cost of organic mixture per millilitre (ml) S0.10 Direct labour hours (DLH) required per bottle 1.5 DLH Minimum wage rate (S per DLH) $5.00 Direct materials are usually paid full in the quarter of purchases billed. All MOOPINKY's production workers are paid faithfully at the end of their month worked. 2021 2022 Quarter 3 Quarter 4 Quarter 1 Quarter 2 Expected Sales (bottles) 24,000 30.000 27.000 27,000 Selling Price $25 S20 $20 The planned reduction in selling price is to compete with its domestic competitors' pricing strategies. Sales of its organic cleansers are usually on account to the company's Singaporean merchandisers. From past experiences, MOOPINKY's accountant, Mimi, projects 70% of the company's quarterly sales will be collected in the quarter invoiced, and the remaining will be collected in the following quarter. Ideally, MOOPINKY's management would like to maintain its quarterly ending balance of its inventories as follows: Finished Goods Inventory 20% of the following quarter's required sales (bottles) Raw Material Inventory one-tenth of the following quarter's required millilitre (m) $20 Continued.... TY The costs cards for the last six-months of 2021 is available as references for MOOPINKY's quarterly budgetary planning: COST CARD: - Manufacturing Overhead Indirect Material Indirect Labour Utilities Unit Variable Costs S0.02 $3.50 $0.08 53.60 Depreciation - Machinery Rent Utilities Maintenance Fixed Costs S510 $6,000 $1,080 S600 S8,190 COST CARD:- Selling & Administrative Expenses Unit Variable Expense Commission 2.00% Delivery 0.50% Travel 1.00% Fixed Expense Sales Salaries $3.000 Depreciation - Office Equipment $400 $3,400 *Variable Expenses are based on Expected Sales Revenue. Mimi further drafts out the following expected cash transactions for the last six-months of 2021: 1. Notes receivable from the last quarter of 2020 worth $100,000 is expected to be collected in the third quarter of 2021. 2. A used van is expected to be retired and sold for cash in the last quarter of 2021 for $10,000 3. All manufacturing overhead costs are expected to be paid in the following quarter. The manufacturing overhead costs for the second quarter of 2021 is expected at $144,270. 4. All selling and administrative expenses are paid in the quarter incurred. Continued.... BAC64 MANAGEMENT ACCOUNTING STRUARY 2011 The company would like to maintain a minimum cash balance of $100,000 every quarter. Any excess of cash will be used to repay borrowings and interests. MOOPINKY Berhad is interested in maintaining its minimum cash balance of S100,000 at the end of each quarter. Any excess of cash is usually used to repay any borrowings or interests due. As of the second quarter of 2021, outstanding cash borrowings were at $60,000. The beginning cash balance for the third quarter is at S100,000. BUDGET REPORT Assuming MOOPINKY Berhad recorded the following actual operating and costs data in Quarter 3 of 2021: Manufacturing Overhead Direct Labour Hours worked Indirect Material Indirect Labour Utilities Depreciation - Machinery Rent Utilities Maintenance 38,100 $762 $133.350 $3.048 $510 $6,000 $1,100 S400 Selling & Administrative Expenses Actual Sales Revenue S650,000 Commission $13,000 Delivery $3,250 Travel S6.500 Sales Salaries S4.500 Depreciation - Office Equipment $400 MOOPINKY's operations manager considers any difference that is less than 5% of the budgeted amount to be immaterial Required: a) Complete the WORKSHEET template for MOOPINKY Berhad for 2021 Sheet1 Operating Budgets-AB Sheet2 Financial Budgets AB Sheet 3 Budgeted Income Statement-AB Sheet 4 Budget Report-A (for Quarter 3) NOTE: Please ignore Budget Report-B sheet. TOTAL 100 MARKS End of Page TXE MOOPINKY BERHAD Sales Budget For the last 6-months ending 31 December 2021 Quarter 3 Quarter 4 TOTAL Expected Unit Sales x Unit Selling Price ($) Total Sales ($) TOTAL MOOPINKY BERHAD Production Budget For the last 6-months ending 31 December 2021 Quarter 3 Quarter 4 Expected Unit Sales Add: Desired ending Finished Goods Inventory Total Required Unit Less: Beginning Finished Goods Inventory Required Production Unit 0 TOTAL 0 MOOPINKY BERHAD Direct Material Budget For the last 6-months ending 31 December 2021 Quarter 3 Quarter 4 Required Production Unit x Direct Materials Required per Prdn Unit (ml). Direct Material Required (ml). Add: Desired ending Direct Material Total Required Direct Material Less: Beginning Direct Material Required Direct Material purchases (ml) x Direct Material Costs ($ per material required) Total cost of Direct Material purchases (S) TOTAL MOOPINKY BERHAD Direct Labour Budget For the last 6-months ending 31 December 2021 Quarter 3 Quarter 4 Required Production Unit x Direct Labour Hour (DLH) Total Required DLH x Direct Labour Costs (S per DLH) Total Direct Labour Costs ($) 0 0 COST CARD: - Manufacturing Overhead Indirect Material Indirect Labour Utilities Unit Variable Costs $0.02 $3.50 $0.08 $3.60 Depreciation - Machinery Rent Utilities Maintenance Fixed Costs S510 $6,000 $1.080 S600 $8,190 Quarter 4 MOOPINKY BERHAD Manufacturing Overhead Budget For the last 6-months ending 31 December 2021 Quarter 3 Direct Labour Hour (activity level) Variable Costs UVC Indirect Material Indirect Labour Utilities Total Variable Costs Fixed Costs Depreciation - Machinery Rent Utilities Maintenance Total Fixed Costs TOTAL MOH POHR COST CARD:- Selling & Administrative Expenses Commission Delivery Travel Unit Variable Expense 2.00% 0.50% 1.00% Sales Salaries Depreciation - Office Equipment Fixed Expense $3,000 $400 $3,400 MOOPINKY BERHAD Selling & Administrative Expense Budget For the last 6-months ending 31 December 2021 Quarter 3 Expected Sales Revenue (activity level) Quarter 4 UVC Variable Expenses Commission Delivery Travel Total Variable Expenses Fixed Expenses Sales Salaries Depreciation - Office Equipment Total Fixed Expenses TOTAL S&A Standard Price Standard Quantity Standard Costs Direct Material per mi ml Direct Labour per DLH DLH | per DLH DLH TOTAL (expected) UC Units s Cost of Goods Manufactured Cost of Goods Sold Cash- minimum Quarterly balance Interest on Borrowings Oustanding Cash Loans from Quarter 2 Collection Terms current next 70% 30% Exp. Cash Collections from Customers Quarter 3 Quarter 4 Balb/f Quarter 3 Quarter 4 Total Collections Payment Terms current 100% Exp. Cash Payment (Disbursements) for DM Quarter 3 Quarter 4 Bal. bf Quarter 3 Quarter 4 Total Payments MOOPINKY BERHAD Cash Budget For the last 6-months ending 31 December 2021 Quarter 3 Quarter 4 Beg. Cash Balance Add: Cash Receipts - Collection from customers Collection of notes receivable - Sales of used van Total Receipts TOTAL AVAILABLE CASH Less: Cash Disbursements DM purchase DL MOH S&A Expense Total Disbursements Excess (Deficiency) of available cash over disbursements FINANCING Add: Borrowings Less: Repayment of Borrowings and Interests ENDING CASH BALANCE MOOPINKY BERHAD Budgeted Income Statement For the last 6-months ending 31 December 2021 Sales Less: Cost of Goods Sold Gross Profit Less: Selling & Administrative Expense Income from Operations Less: Interest Expense Income before Income Tax Less: Income Tax Expense 0.0% NET INCOME Income Tax Rate MOOPINKY BERHAD Quarterly Manufacturing Overhead STATIC Budget REPORT for Quarter 3 ending 30 September 2021 DIFFERENCE BUDGETED ACTUAL Amount F/UF 38,100 UVC $762 S133,350 $3,048 $137.160 Direct Labour Hour Variable Costs Indirect Material Indirect Labour Utilities Total Variable Costs Fixed Costs Depreciation - Machinery Rent Utilities Maintenance Total Fixed Costs TOTAL MOH S510 $6,000 SI,100 $400 SR010 $145,170 Direct Labour Hour Variable Costs Indirect Material Indirect Labour Utilities Total Variable Costs MOOPINKY BERHAD Quarterly Manufacturing Overhead FLEXIBLE Budget REPORT for Quarter 3 ending 30 September 2021 DIFFERENCE BUDGETED ACTUAL Amount F/UF 38,100 UVC S762 $133.350 $3,048 $137.160 Fixed Costs Depreciation - Machinery Rent Utilities Maintenance Total Fixed Costs TOTAL MOH S510 $6,000 SI.100 $400 $8010 $145.170 % MOOPINKY Sdn. Bhd. Quarterly Selling & Administrative Expense STATIC Budget REPORT for the third quarter ended 30 September 2021 DIFFERENCE BUDGETED ACTUAL Amount F/UF Expected Sales Revenue $650,000 Variable Expenses UVC Commission $13,000 Delivery $3,250 Travel $6,500 Total Variable Expenses $22.750 Fixed Expenses Sales Salaries 4,500 Depreciation - Office Equipment 400 Total Fixed Expenses 4.900 TOTAL S&A $27.650 MOOPINKY Sdn. Bhd. Quarterly Selling & Administrative Expense FLEXIBLE Budget REPORT for the third quarter ended 30 September 2021 DIFFERENCE BUDGETED ACTUAL Amount F/UF Expected Sales Revenue $650.000 Variable Expenses UVC Commission $13,000 Delivery S3.250 Travel $6,500 Total Variable Expenses $22.750 Fixed Expenses Sales Salaries 4,500 Depreciation - Office Equipment Tora Fixed Expenses TOTAL S&A 400 4.900 $27.650