I need a d aomplete accounting simulation. I need a sales budget, a production budget, a raw material budget, and a manufacturing overhead budget $($including indirect labor wages & benefits, depreciation, property tax for the production facility, and other indirect expenses$)$

At the beginning:

ASSETS

Current Assets:

Cash: $$6,213$

Accounts Receivable: $$683,620$

Prepaid Taxes: $-$

Prepaid Expenses: $-$

Raw Material Stocks: $$75,896$

Finished Product Stocks: $$135,489$

Temporary Difference on Deferred Tax Assets: $-$

Fixed Assets:

Costs: $$1,819,664$

Accumulated Depreciation: $($$$983,277)$

Total Assets: $$1,737,604$

LIABILITIES

Current Liabilities:

Bank Loan: $$24,888$

Accounts Payable: $$129,590$

Lease Obligations: $-$

Taxes Payable: $-$

Long$-$term Liabilities:

Long$-$term Debts: $$475,782$

Total Liabilities: $$630,260$

SHAREHOLDERS' EQUITY

Share Capital: $$750,445$

Retained Earnings: $$356,899$

Total Equity: $$1,107,344$

Total Liabilities and Equity: $$1,737,604$

There are $3$ months in a quarter.

There are $4$ quarters in a year.

There are $12$ months in a year.

Quarterly sales in jars for quarter $1$ of year t$+1$: $$299,487$

Quarterly sales in jars for quarter $1$ of year t$+2$: $$350,268$

Expected selling price in the last quarter of year t: $$5\mathrm{.}01$

Every year, the company makes a significant portion of its sales approaching the holiday season. Sales remain stable for all other quarters except the fourth quarter. The growth in quantities sold for quarter $4$ is approximately $47\mathrm{.}4\%.$

Competition is fierce in the food industry, which is why the company plans slight price increases for the next $2$ fiscal years. Here are the price increases relative to the previous quarter:

$1$st quarter year t$+1$: $0\mathrm{.}0\%$

$2$nd quarter year t$+1$: $0\mathrm{.}4\%$

$3$rd quarter year t$+1$: $0\mathrm{.}5\%$

$4$th quarter year t$+1$: $2\mathrm{.}6\%$

$1$st quarter year t$+2$: $1\mathrm{.}0\%$

$2$nd quarter year t$+2$: $0\mathrm{.}5\%$

To encourage prompt payment from customers, BONNE CONFITURE! offers the following credit terms to its customers: $0\mathrm{.}9\%/10,$ net $90.$

Accounts receivable collection period:

Within $10$ days of invoicing: $13\%$

During the quarter $($but more than $10$ days after invoicing$)$: $60\%$

The following quarter: $20\%$

The second quarter following: $7\%$

Beginning accounts receivable includes a portion of sales from Q$3$ and Q$4$ of year t$.$ Here are the percentages of accounts receivable that will be collected in Q$1$ and Q$2$ of year t$+1$ related to sales in Q$3$ and Q$4$ of year t:

Percentage of accounts receivable collected in Q$1$ year t$+1$: $73\%$

Percentage of accounts receivable collected in Q$2$ year t$+1$: $27\%$

Stock management:

There is no inventory of work in progress at the beginning or end.

Sales in the last quarter are always much higher due to the holiday season. The company increases its jam jar stocks according to this increased demand. Here are the jam jar requirements as a percentage of forecasted sales $($in jars$)$ for the following quarter:

$1$st quarter: $11\%$

$2$nd quarter: $36\%$

$3$rd quarter: $67\%$

$4$th quarter: $10\%$

The unit cost $($$ CAD$)$ of jam jar stock at the beginning is $$4\mathrm{.}00.$

Attention: Use the cost of sales for each quarter and not the annual average to value finished goods inventory.

The company uses rational costing. The basis for allocating manufacturing overhead costs is the number of jam jars.

Raw material inventory at the end corresponds to a percentage of raw material requirements for production in the following quarter: $20\%.$

Production Information:

Purchase price $($$ USD $/100$ ml$)$ for raw materials in inventory in the last quarter of year t: Price: $$0\mathrm{.}22$ USD, Quantity: $100$ ml$.$

Raw material prices vary widely based on market index. Here are the estimated prices for year t$+1($$ USD $/100$ ml$)$:

$1$st quarter: $$0\mathrm{.}26$ USD $/100$ ml

$2$nd quarter: $$0\mathrm{.}32$ USD $/100$ ml

$3$rd quarter: $$0\mathrm{.}22$ USD $/100$ ml

$4$th quarter: $$0\mathrm{.}28$ USD $/100$ ml

Quantity $($ml$)$ of raw materials expected per jam jar: $646$ ml$.$

Purchasing policy for raw materials:

During the quarter: $85\%$

The following quarter: $15\%$

The company incurs several costs to support production. These costs are allocated by quarter based on units produced. Note that these costs are disbursed at the same rate as their allocation, except for property taxes.

Annual utility cost: $$589,234$

Annual maintenance and repair cost: $$850,003$

Annual property tax for the production facility: $$124,875$

Property taxes must be paid in full in the first quarter.

Salary Information:

The manufacturing process being highly automated, there is no direct labor.

The table below includes the information needed to calculate the payroll:

Production Manager: $$84,822$

Laboratory Technicians and Quality Control: $$67,566$

Process Engineers: $$80,362$

Administrative Managers: $$63,285$

Sales Director: $$52,266$

All employees will receive a bonus on December $1$ of year t$+1$ based on budget attainment. The bonus amount per employee is $$2,521.$ In past years, the required performance target has always been met.

The value of the company's benefits equals a certain percentage of the payroll, excluding bonuses. This percentage is $18\%.$ This amount is paid on payday.

Assets:

Cash: $$6,213$