Required: Using the data given above, prepare the following budgets along with other supportive schedules for the quarter (June- July August ) of the year 2023.

Cash budget (with support schedule (payment and collection sechedual)).

solve the question using excel (use functions)

Lamar fashion designer Acct 202 Case study Lamar is a fashion designer. She makes a unique women dress and currently reviewing their production data for a new dress for summer 2023 season. The management needs your help to prepare a budgeted figure for this new product. The owner of Lamar has provided the following data: Budgeted sales for the next five months are as follows: - Unit selling price SR 1000 - lamar wants the finished closing stock equals to 8+10% of the following month's budgeted sales in units. - Each dress needs 5 Meters of fabric, each meter costs SR 100 . lama would like the raw materials closing stock equals to 10 Meters, and at the end of Feb Lamar has 10 Meters of fabric. - 6 labor hours are required for each unit produced, each hour costs SR 35 and will be paid as incurred. - Unit variable manufacturing overhead is SR 40 per unit, and fixed manufacturing overhead cost is SR 300 per month will be paid as incurred. - 75% of sales are for cash. 25% are on credit and customers pay half of their debt in the month following sale and the balance one month after that. - The cost of fabric is paid for one month after purchase. - The closing balances at the end of May is SR 15,000. - Lamar pays a cash dividend of SR 2,000 in August Lamar fashion designer Acct 202 Case study Lamar is a fashion designer. She makes a unique women dress and currently reviewing their production data for a new dress for summer 2023 season. The management needs your help to prepare a budgeted figure for this new product. The owner of Lamar has provided the following data: Budgeted sales for the next five months are as follows: - Unit selling price SR 1000 - lamar wants the finished closing stock equals to 8+10% of the following month's budgeted sales in units. - Each dress needs 5 Meters of fabric, each meter costs SR 100 . lama would like the raw materials closing stock equals to 10 Meters, and at the end of Feb Lamar has 10 Meters of fabric. - 6 labor hours are required for each unit produced, each hour costs SR 35 and will be paid as incurred. - Unit variable manufacturing overhead is SR 40 per unit, and fixed manufacturing overhead cost is SR 300 per month will be paid as incurred. - 75% of sales are for cash. 25% are on credit and customers pay half of their debt in the month following sale and the balance one month after that. - The cost of fabric is paid for one month after purchase. - The closing balances at the end of May is SR 15,000. - Lamar pays a cash dividend of SR 2,000 in August