Prepare a master budget for McGregor Pharmacy Company for the year ending December 31, 2021 using the following information. Prepare it per quarter. Use the tables provided by the professor.

Prepare the Sales Budget assuming:

1. Expected sales volume: 8,000 units for the first quarter, an increase of 20% is expected for the second quarter, a decrease of 10% for the third quarter, and an increase of 25% for the fourth quarter.
2. The sales price should be $75.00 for the first two quarters and $82.50 for the last two quarters.

Name of the company Sales Budget Date 1 2 3 4 Total Expected unit sales Unit selling price Total salesName of the company Production Budget Date Expected unit sales Add: desired ending finished goods units Total required units Less: beginning finished goods units Required production unitsUnits to be produced Multiply by Direct material per unit Direct Materials units required for production Add: Desired ending direct material units Total material required Less: Beginning direct material units Direct Material units required to be purchases Cots pcr Direct material units Total cost of Direct Material purchased Name of the company Direct Material Budget Date - Name of the company Direct Labor Budget Date Units to be produced Direct labor time per unit Total required direct labor hours Direct labor cost per hour Total direct labor costDirect labor hours Variable Costs indirect material indirect labor other variable cost Maintenance Total Variable Costs Fixed Cost Supervisory salaries Depreciation Property taxesx and insurance maintenance Total Fixed Cost Total manufacturing cost Manufacturing overhead cost per unit Name of the company Manufacturing Overhead Budget Date Total Name of the company Selling and Administrative Budget Date 2 4 Total Budgeted sales in units Variable expenses Sales Commission Freight-out Miscellaneous Other variable cost Total variable expenses Fixed expenses Advertising Sales salaries Office salaries Depreciation Property taxes and insurance Miscellaneous total fixed cost Total selling and administrative expensesSales Cost of Goods Sold Gross Prot Selling and Administrative Expenses Operating Income Interest expense Income before taxes Taxes Net Income Name of the company Budgeted Income Statement Date Name of the company Cash budget Date 2 3 4 Cash Collection Beginning Cash Balance Sales Accounts Receivable Short term investment Long-Term Investment Issuance of Common Stock Total Receipts Total available cash Cash Disbursement Accounts Payable Direct Material Direct labor manufacturing overhead Selling and administrative expenses Purchase of truck Annual income taxes total disbursement Excess (deficiency) of availble cash over cash disbursement financing Add: borrowings Less: repayments including interest Ending cash balanceName of the company Budgeted balance sheet Date Assets Current assets Cash Account Receivable Finished Good Inventory Raw material inventory total current assets Property, plant and equipment Building and equipment Less: accumulated depreciation Total property, plant and equipment Total assets Liabilities and stockholders' equity Liabilities Accounts payable Total liabilities Stockholders equity Common stock Retained earnings Total stockholders' equity Total liabilities and stockholder's equity