Objective: This performance task evaluates your ability to create a comprehensive master

budget tailored to a business environment in the United Arab Emirates. The task involves

preparing various budgets, including sales, cash collection, purchases, production, expenses,

and cash budget. Additionally, you will need to demonstrate an understanding of credit terms

relevant to the UAE market.

Scenario: You are the financial manager of "SmartTech Innovations," a growing technology

company based in Dubai, UAE. Specializing in cutting

$-$

edge electronic gadgets, your task is to

create a master budget for the upcoming fiscal year

$($

$1$

$2$

$$months

$)$

$$based on the provided

information, considering the specific business landscape and practices in the UAE.

Information:

Sales Forecast:

January: AED

$3$

$5$

$0$

$,$

$0$

$0$

$0$

February: AED

$4$

$2$

$0$

$,$

$0$

$0$

$0$

March: AED

$5$

$0$

$0$

$,$

$0$

$0$

$0$

April: AED

$4$

$8$

$0$

$,$

$0$

$0$

$0$

May: AED

$4$

$0$

$0$

$,$

$0$

$0$

$0$

June: AED

$4$

$5$

$0$

$,$

$0$

$0$

$0$

July: AED

$5$

$2$

$0$

$,$

$0$

$0$

$0$

August: AED

$5$

$8$

$0$

$,$

$0$

$0$

$0$

September: AED

$6$

$5$

$0$

$,$

$0$

$0$

$0$

October: AED

$6$

$2$

$0$

$,$

$0$

$0$

$0$

November: AED

$5$

$6$

$0$

$,$

$0$

$0$

$0$

December: AED

$7$

$0$

$0$

$,$

$0$

$0$

$0$

Credit Terms:

$8$

$0$

$\%$

$$of sales are credit sales with a

$3$

$0$

$-$

day collection period.

The remaining

$2$

$0$

$\%$

$$are cash sales.

Cash Collection:

$7$

$0$

$\%$

$$of credit sales are collected in the month following the sale.

The remaining

$3$

$0$

$\%$

$$are collected in the second month following the sale.

Purchases:

The cost of goods sold is

$6$

$0$

$\%$

$$of sales.

The company maintains a policy of ending each month with

$2$

$0$

$\%$

$$of the next

month's cost of goods sold in inventory.

Production:

The company aims to have an ending finished goods inventory equal to

$1$

$0$

$\%$

$$of

the next month's sales.

Expenses:

Monthly operating expenses

$($

excluding cost of goods sold

$)$

$$are estimated to be

AED

$5$

$0$

$,$

$0$

$0$

$0$

$.$

Cash Budget:

The company wants to maintain a minimum cash balance of AED

$1$

$0$

$0$

$,$

$0$

$0$

$0$

Find December Purchases Budget:

$\backslash$table$[[$Month$,\backslash$table$[[$Cost of Goods Sold of$],[$Sales$)]],\backslash$table$[[$Desired Ending$],[$Inventory$]],\backslash$table$[[$Total Purchases$],[($AED$)]]],[$January$,210,000,50,400,218,400],[$February$,252,000,60,000,261,600],[$March$,300,000,57,600,297,600],[$April$,288,000,48,000,278,400],[$May$,240,000,54,000,246,000],[$June$,270,000,62,400,278,400],[$July$,312,000,69,600,319,200],[$Align Right$],[$August$,348,000,78,000,356,400],[$September$,390,000,74,400,386,400],[$October$,372,000,67,200,364,800],[$November$,336,000,84,000,352,800],[$December$,420,000,,]],$ please: December is missing, find it please