You have been contracted as a consultant by Kakao Ltd Kakao produces and sells high quality boxes of chocolates Kakao is managed by its two owners and its fiscal year end is December 31st It is January 4, 2022, and Kakao just completed its fifth year end (December 31, 2021) The owners of Kakao are considering using a detailed Master Budget for the 2022 fiscal year to plan and control operations You have been contracted to complete the following I Master Budget for Kakao for each quarter of 2022 and for the 2022 fiscal year in total using the information in the Data section The Master Budget will detail each quarters activity and the activity for the 2022 fiscal year in total The following component budgets must be included i Beginning Balance Sheet (Data Item 13) ii Sales Budget iii Schedule of Cash Collections iv Production Budget v Direct Materials Budget vi Schedule of Cash Disbursements for Raw Materials vii Direct Labor Budget viii Manufacturing Overhead Budget i Include cash disbursements for total overhead expenses ix Selling and Administrative Expense Budget i Include cash disbursements for selling and administrative expenses x Cash Budget Following for the 2022 fiscal year in total (these should not be quarterly) xi Cost of Goods Manufactured Budget xii Cost of Goods Sold Budget xiii Budgeted Income Statement (using absorption costing) xiv Budgeted Balance Sheet The Cash Budget and Budgeted Income Statement are completed at the same time as when you build a formula to account for tax expenses and a set of formulas to account for cash outflow in the Cash Budget The Budgeted Balance Sheet is completed last II The owners of Kakao would like to improve cash flow They have not taken a dividend since the company's inception, and they would like to start paying themselves dividends in 2022 without using any short term financing To accomplish this goal, they are considering the following changes i ii III An increase in the sales price from $25 00 per unit to $26 50 per unit in 2022 (assume the change occurs January 1, 2022) Tightening of credit terms to ensure more prompt collection of accounts receivable Accounts receivable would now be collected as 80 in the quarter of sale and 20 in the following quarter The impact of the changes in (i) and (ii) is an anticipated drop in sales volume of 5 compared to the original estimates for every quarter for 2022 and 2023 If Kakao's owners want to leave $50,000 of cash in Kakao at the end of the 2022 fiscal year, what is the total amount of dividends that they can pay out of the company at December 31, 20222 III The owners of Kakao have asked you to prepare a Report discussing the following The overall importance usefulness of budgeting Difficulties faced relating to preparing the budget i ii 2

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Nov 30, 2021

You have been contracted as a consultant by Kakao Ltd. Kakao produces and sells high quality boxes of chocolates. Kakao is managed by its two

You have been contracted as a consultant by Kakao Ltd. Kakao produces and sells high quality boxes of chocolates. Kakao is managed by its two owners and its fiscal year end is December 31st. It is January 4, 2022, and Kakao just completed its fifth year-end (December 31, 2021). The owners of Kakao are considering using a detailed Master Budget for the 2022 fiscal year to plan and control operations. You have been contracted to complete the following:

I. Master Budget for Kakao for each quarter of 2022 and for the 2022 fiscal year in total using the information in the “Data” section. The Master Budget will detail each quarter’s activity and the activity for the 2022 fiscal year in total. The following component budgets must be included:

i. Beginning Balance Sheet (“Data” Item 13)
ii. Sales Budget
iii. Schedule of Cash Collections
iv. Production Budget
v. Direct Materials Budget
vi. Schedule of Cash Disbursements for Raw Materials
vii. Direct Labor Budget
viii. Manufacturing Overhead Budget
i. Include cash disbursements for total overhead expenses
ix. Selling and Administrative Expense Budget
i. Include cash disbursements for selling and administrative expenses
x. Cash Budget

Following for the 2022 fiscal year in total (these should not be quarterly):

xi. Cost of Goods Manufactured Budget
xii. Cost of Goods Sold Budget
xiii. Budgeted Income Statement (using absorption costing)
xiv. Budgeted Balance Sheet

i. The Cash Budget and Budgeted Income Statement are completed at the same time as when you build a formula to account for ta

iv. V. Observations and recommendations you would make based on the Cash Budget prepared in Requirement I The impacts of the

Data Kakao will base the 2022 Master Budget on the following information: 1. Expected sales, in units, for the four quarters

5. Each unit requires the following direct inputs: a. 300 grams of direct material which is available at a price of $0.015/gr

Maintenance $24,500 Utilities $34,500 Depreciation $22,000 Total $206,000 All fixed overhead items are paid evenly each quart

11. Kakao makes quarterly income tax installments based on the projected taxable income for the year. The company is subject

Raw Material Inventory Finished Goods Inventory Buildings and Equipment Accumulated Depreciation SO SO $2,000,000 ($131,220)

The Cash Budget and Budgeted Income Statement are completed at the same time as when you build a formula to account for tax expenses and a set of formulas to account for cash outflow in the Cash Budget The Budgeted Balance Sheet is completed last II. The owners of Kakao would like to improve cash flow. They have not taken a dividend since the company's inception, and they would like to start paying themselves dividends in 2022 without using any short-term financing. To accomplish this goal, they are considering the following changes: i. ii. III. An increase in the sales price from $25.00 per unit to $26.50 per unit in 2022 (assume the change occurs January 1, 2022). Tightening of credit terms to ensure more prompt collection of accounts receivable. Accounts receivable would now be collected as 80% in the quarter of sale and 20% in the following quarter. The impact of the changes in (i) and (ii) is an anticipated drop in sales volume of 5% compared to the original estimates for every quarter for 2022 and 2023 If Kakao's owners want to leave $50,000 of cash in Kakao at the end of the 2022 fiscal year, what is the total amount of dividends that they can pay out of the company at December 31, 20222 III. The owners of Kakao have asked you to prepare a Report discussing the following: The overall importance/usefulness of budgeting Difficulties faced relating to preparing the budget i. ii. 2