Dimsdale Sports, a merchandising company, reports the following balance sheet at December 31. To prepare...

90.2K

Verified Solution

Question

Accounting

imageimage Dimsdale Sports, a merchandising company, reports the following balance sheet at December 31. To prepare a master budget for January, February, and March, use the following Information. a. The company's single product is purchased for $20 per unit and resold for $57 per unlt. The Inventory level of 4,500 units on December 31 is more than management's desired level, which is 20% of the next month's budgeted sales units. Budgeted sales are January, 6,500 unlts; February, 9,000 unlts; March, 11,000 unlts; and Aprll, 10,000 unlts. All sales are on credit. b. Cash recelpts from sales are budgeted as follows: January, $249,675; February, $716,820; March, $513,072. c. Cash payments for merchandise purchases are budgeted as follows: January, $65,000; February, $300,200; March, $98,400. d. Sales commissions equal to 20% of sales dollars are pald each month. Sales salarles (excluding commlssions) are $4,500 per month. e. General and admInIstratlve salarles are $13,000 per month. Malntenance expense equals $2,000 per month and Is pald In cash. f. New equipment purchases are budgeted as follows: January, $40,800; February, $93,600; and March, $24,000. Budgeted depreclation expense Is January, $6,300; February, $7,275; and March, $7,525. g. The company budgets a land purchase at the end of March at a cost of $175,000, which will be pald with cash on the last day of the month. h. The company has an agreement with Its bank to obtaln addlitional loans as needed. The Interest rate is 1% per month and interest is pald at each month-end based on the beginning-month balance. Partlal or full payments on these loans are made on the last day of the month. The company malntains a minimum ending cash balance of $20,500 at the end of each month. I. The Income tax rate for the company is 43%. Income taxes on the first quarter's income will not be pald untll Aprll 15. Requlred: Prepare a master budget for the months of January, February, and March that has the following budgets: 1. Sales budgets. 2. Merchandlse purchases budgets. 3. Selling expense budgets. 4. General and admInIstratlve expense budgets. Hint: Depreclation is Included in the general and adminlstratlve budget for merchandisers. 5. Capltal expenditures budgets. 6. Cash budgets. 7. Budgeted Income statement for entire quarter (not monthly) ended March 31. 8. Budgeted balance sheet as of March 31

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students