Near the end of 2019, the management of Dimsdale Sports Co., a
merchandising company, prepared the following estimated balance
sheet for December 31, 2019.
DIMSDALE SPORTS COMPANY Estimated Balance Sheet December 31, 2019 |
||||||
Assets | ||||||
Cash | $ | 36,000 | ||||
Accounts receivable | 520,000 | |||||
Inventory | 135,000 | |||||
Total current assets | $ | 691,000 | ||||
Equipment | 600,000 | |||||
Less: Accumulated depreciation | 75,000 | |||||
Equipment, net | 525,000 | |||||
Total assets | $ | 1,216,000 | ||||
Liabilities and Equity | ||||||
Accounts payable | $ | 340,000 | ||||
Bank loan payable | 12,000 | |||||
Taxes payable (due 3/15/2020) | 88,000 | |||||
Total liabilities | $ | 440,000 | ||||
Common stock | 473,500 | |||||
Retained earnings | 302,500 | |||||
Total stockholders’ equity | 776,000 | |||||
Total liabilities and equity | $ | 1,216,000 | ||||
To prepare a master budget for January, February, and March of
2020, management gathers the following information.
Required:
Prepare a master budget for each of the first three months of 2020;
include the following component budgets.
1. Monthly sales budgets.
2. Monthly merchandise purchases budgets.
3. Monthly selling expense budgets.
solution:
DIMSDALE SPORTS COMPANY | |||
Sales Budget | |||
January, February, and March 2020 | |||
Budgeted Unit Sales | Budgeted Unit Price | Budgeted Sales Dollars | |
Jan-20 | 6750 | $60.00 | $405,000.00 |
Feb-20 | 8750 | $60.00 | $525,000.00 |
Mar-20 | 10500 | $60.00 | $630,000.00 |
Totals for the First quarter | 26000 | $60.00 | $1,560,000.00 |
DIMSDALE SPORTS COMPANY | |||
Merchandise purchases budget | |||
January, February, and March 2020 | |||
January | February | March | |
Next month's budgeted sales (units) | 8750 | 10500 | 10500 |
Ratio of inventory to future sales | 20% | 20% | 20% |
Desired ending inventory | 1750 | 2100 | 2100 |
Budgeted sales units | 6750 | 8750 | 10500 |
Required units of available merchandise | 8500 | 10850 | 12600 |
Beginning inventory | 4500 | 1750 | 2100 |
Units to be purchased | 4000 | 9100 | 10500 |
Cost per unit | $30.00 | $30.00 | $30.00 |
Budgeted cost of purchases | $120,000.00 | $273,000.00 | $315,000.00 |
DIMSDALE SPORTS COMPANY | ||||
Selling expenses Budget | ||||
January, February, and March 2020 | ||||
January | February | March | Total | |
Budgeted sales | $405,000.00 | $525,000.00 | $630,000.00 | $1,560,000.00 |
Sales commission (%) | 20% | 20% | 20% | 20% |
Sales commission | $81,000.00 | $105,000.00 | $126,000.00 | $312,000.00 |
Sales salaries | $5,000.00 | $5,000.00 | $5,000.00 | $15,000.00 |
Total selling expenses | $86,000.00 | $110,000.00 | $131,000.00 | $327,000.00 |
Near the end of 2019, the management of Dimsdale Sports Co., a merchandising company, prepared the...
Near the end of 2019, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2019. DIMSDALE SPORTS COMPANY Estimated Balance Sheet December 31, 2019 Assets Cash $ 36,500 Accounts receivable 520,000 Inventory 105,000 Total current assets $ 661,500 Equipment 612,000 Less: Accumulated depreciation 76,500 Equipment, net 535,500 Total assets $ 1,197,000 Liabilities and Equity Accounts payable $ 375,000 Bank loan payable 12,000 Taxes payable (due 3/15/2020) 89,000 Total liabilities $ 476,000...
Near the end of 2019, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2019. DIMSDALE SPORTS COMPANY Estimated Balance Sheet December 31, 2019 Assets Cash $ 36,500 Accounts receivable 520,000 Inventory 105,000 Total current assets $ 661,500 Equipment 612,000 Less: Accumulated depreciation 76,500 Equipment, net 535,500 Total assets $ 1,197,000 Liabilities and Equity Accounts payable $ 375,000 Bank loan payable 12,000 Taxes payable (due 3/15/2020) 89,000 Total liabilities $ 476,000...
Near the end of 2019, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2019. DIMSDALE SPORTS COMPANY Estimated Balance Sheet December 31, 2019 Assets Cash $ 36,000 Accounts receivable 520,000 Inventory 135,000 Total current assets $ 691,000 Equipment 600,000 Less: Accumulated depreciation 75,000 Equipment, net 525,000 Total assets $ 1,216,000 Liabilities and Equity Accounts payable $ 340,000 Bank loan payable 12,000 Taxes payable (due 3/15/2020) 88,000 Total liabilities $ 440,000...
Near the end of 2019, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2019. DIMSDALE SPORTS COMPANY Estimated Balance Sheet December 31, 2019 Assets Cash $ 36,000 Accounts receivable 520,000 Inventory 100,000 Total current assets $ 656,000 Equipment 528,000 Less: Accumulated depreciation 66,000 Equipment, net 462,000 Total assets $ 1,118,000 Liabilities and Equity Accounts payable $ 365,000 Bank loan payable 14,000 Taxes payable (due 3/15/2020) 89,000 Total liabilities $ 468,000...
Near the end of 2019, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2019. DIMSDALE SPORTS COMPANY Estimated Balance Sheet December 31, 2019 Assets Cash $ 36,000 Accounts receivable 520,000 Inventory 135,000 Total current assets $ 691,000 Equipment 600,000 Less: Accumulated depreciation 75,000 Equipment, net 525,000 Total assets $ 1,216,000 Liabilities and Equity Accounts payable $ 340,000 Bank loan payable 12,000 Taxes payable (due 3/15/2020) 88,000 Total liabilities $ 440,000...
Near the end of 2019, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2019. DIMSDALE SPORTS COMPANY Estimated Balance Sheet December 31, 2019 Assets Cash $ 37,000 Accounts receivable 520,000 Inventory 100,000 Total current assets $ 657,000 Equipment 648,000 Less: Accumulated depreciation 81,000 Equipment, net 567,000 Total assets $ 1,224,000 Liabilities and Equity Accounts payable $ 355,000 Bank loan payable 13,000 Taxes payable (due 3/15/2020) 89,000 Total liabilities $ 457,000...
Near the end of 2019, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2019. DIMSDALE SPORTS COMPANY Estimated Balance Sheet December 31, 2019 Assets Cash $ 35,500 Accounts receivable 520,000 Inventory 100,000 Total current assets $ 655,500 Equipment 540,000 Less: Accumulated depreciation 67,500 Equipment, net 472,500 Total assets $ 1,128,500 Liabilities and Equity Accounts payable $ 365,000 Bank loan payable 13,000 Taxes payable (due 3/15/2020) 89,000 Total liabilities $ 467,000...
Near the end of 2019, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2019. DIMSDALE SPORTS COMPANY Estimated Balance Sheet December 31, 2019 Assets Cash $ 36,500 Accounts receivable 520,000 Inventory 105,000 Total current assets $ 661,500 Equipment 588,000 Less: Accumulated depreciation 73,500 Equipment, net 514,500 Total assets $ 1,176,000 Liabilities and Equity Accounts payable $ 380,000 Bank loan payable 12,000 Taxes payable (due 3/15/2020) 91,000 Total liabilities $ 483,000...
Near the end of 2019, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2019. DIMSDALE SPORTS COMPANY Estimated Balance Sheet December 31, 2019 Assets Cash $ 36,500 Accounts receivable 520,000 Inventory 105,000 Total current assets $ 661,500 Equipment 588,000 Less: Accumulated depreciation 73,500 Equipment, net 514,500 Total assets $ 1,176,000 Liabilities and Equity Accounts payable $ 380,000 Bank loan payable 12,000 Taxes payable (due 3/15/2020) 91,000 Total liabilities $ 483,000...
Near the end of 2019, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2019. DIMSDALE SPORTS COMPANY Estimated Balance Sheet December 31, 2019 Assets Cash $ 35,500 Accounts receivable 520,000 Inventory 90,000 Total current assets $ 645,500 Equipment 600,000 Less: Accumulated depreciation 75,000 Equipment, net 525,000 Total assets $ 1,170,500 Liabilities and Equity Accounts payable $ 350,000 Bank loan payable 12,000 Taxes payable (due 3/15/2020) 88,000 Total liabilities $ 450,000...