Problem $16-11$

Use the input data provided here to prepare a monthly cash bodget for the months of July through December$/$

Payments for labor and raw materials

in month after the costs are incurred

Lease payments

General and administrative salary payments

Depreciation charges

Miscellancous expense payments

Base Case Sales

Labor & raw material costs incurred

Other Amounts

Income tax payments made in Sep & Dec

New design studio payment nade in October

Cash on hand July $1$

Minimum cash balance

Sales adjustment factor $($percent of base case sales

a$.$ Prepare a monthly cash budget for the last $6$ months of the year.

The Cash Budget

Collections and purchases worksheet

Sales Times Adjustment Factor

Collections

During month of sale

During $1$st month after sale

During $2$nd month after sale

Total collections

Expenditures

Labor and raw materials

Payments for labor and raw materials

Cash inflows and outflows for the month

Collections

Payments for labor and raw materials

General and administrative salaries

Lease payments

Miscellaneous expenses

Income tax payments

Design studio payment

Total payments

Net cash in flow $($autflow$)$ durino manth