Question

You are the new manager of the local Tronic Electronics store. Top management of Tronic Electronics is convinced that management training should include the active participation of store managers in the budgeting process. You have been asked to prepare a complete master budget for your store for​ June, July, and August. All accounting is done centrally so you have no expert help on the premises. In​ addition, tomorrow the branch manager and the assistant controller will be here to examine your​ work; at that​ time, they will assist you in formulating the final budget document. The idea is to have you prepare the initial budget on your own so that you gain more confidence about accounting matters. You want to make a favorable impression on your​ superiors, so you gather the following financial statement and sales data as of May​ 31, 20X8:

Prepare the cash budget for​ June, July, and August. Recall that all borrowing and repayments of principal are made in multiples of​ $1,000. ​(Complete all answer boxes. Use a minus sign or parentheses for cash outflows and cash deficiencies. Round your answer for Borrowing to the nearest thousand​ dollars.

Please see additional data. As well as a snip of the info I've gathered so far. I'm stuck. June July Beginning cash balance 9,900 3,000 Minimum cash balance required 6,900 Available cash balance Cash receipts and dis


i More Info Credit sales are 70% of total sales. Seventy percent of each credit account is collected in the month following t
Data Table - X $ Cash Inventory Accounts receivable Net furniture and fixtures 9,900 Recent and Projected Sales 183,600 April

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Date: 3olution Budget Cash Jult 3,5003S33 3000 3500 June Aruguat 5egianigch balance910u Min. cah bal, regd 300D 3,000 3S33 9,ComputotiOnoespectod coltection fromm tomers June yCredit Sqlom (150000 D.3) 31,5OO Credi Sales(18o00D 10.7 80.9) Apa ৪৪,260Computation of Merchon dise rchoeso Aug 183 600136,0ou36,000 34,06)3600) 3e০ July June 02,000 (102,000) 860D los Op dtock O P

Add a comment
Know the answer?
Add Answer to:
You are the new manager of the local Tronic Electronics store. Top management of Tronic Electronics is convinced that ma...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • You have just been hired as a new management trainee by Earrings Unlimited, a distributor of...

    You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have...

  • Developing a Master Budget for a Merchandising Organization Dils Brother Department Store prepares budgets quarterly. The...

    Developing a Master Budget for a Merchandising Organization Dils Brother Department Store prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for 2017. Dils Brother Department Store Balance Sheet March 31, 2017 Assets    Liabilities and Stockholders' Equity Cash $ 4,000    Accounts payable $31,000 Accounts receivable 31,000    Dividends payable 15,000 Inventory 36,000    Rent payable 3,000 Prepaid Insurance 3,000    Stockholders' equity 50,000 Fixtures 25,000 Total assets $99,000    Total liabilities...

  • You have just been hired as a new management trainee by Earrings Unlimited, a distributor of...

    You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have...

  • Developing a Master Budget for a Merchandising Organization Dils Brother Department Store prepares budgets quarterly. The...

    Developing a Master Budget for a Merchandising Organization Dils Brother Department Store prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for 2017. Dils Brother Department Store Balance Sheet March 31, 2017 Assets Liabilities and Stockholders' Equity Cash $ 4,000 Accounts payable $31,000 Accounts receivable 31,000 Dividends payable 15,000 Inventory 36,000 Rent payable 3,000 Prepaid Insurance 3,000 Stockholders' equity 50,000 Fixtures 25,000 Total assets $99,000 Total liabilities and equity $99,000 Actual and forecasted...

  • Developing a Master Budget for a Merchandising Organization Dils Brother Department Store prepares budgets quarterly. The...

    Developing a Master Budget for a Merchandising Organization Dils Brother Department Store prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for 2017. Dils Brother Department Store Balance Sheet March 31, 2017 Assets Liabilities and Stockholders' Equity Cash $ 4,000 Accounts payable $31,000 Accounts receivable 31,000 Dividends payable 15,000 Inventory 36,000 Rent payable 3,000 Prepaid Insurance 3,000 Stockholders' equity 50,000 Fixtures 25,000 Total assets $99,000 Total liabilities and equity $99,000 Actual and forecasted...

  • You have just been hired as a new management trainee by Earrings Unlimited, a distributor of...

    You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have...

  • Developing a Master Budget for a Merchandising Organization Peyton Department Store prepares budgets quarterly. The following...

    Developing a Master Budget for a Merchandising Organization Peyton Department Store prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for 2010. PEYTON DEPARTMENT STORE Balance Sheet March 31, 2010 Assets Liabilities and Stockholders' Equity Cash $4,000 Accounts payable $26,000 Accounts receivable 25,000 Dividends payable 17,000 Inventory 30,000 Rent payable 3,000 Prepaid Insurance 2,000 Stockholders' equity 40,000 Fixtures 25,000 Total assets $86,000 Total liabilities and equity $86,000 Actual and forecasted sales for selected...

  • Developing a Master Budget for a Merchandising Organization Peyton Department Store prepares budgets quarterly. The following...

    Developing a Master Budget for a Merchandising Organization Peyton Department Store prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for 2010. PEYTON DEPARTMENT STORE Balance Sheet March 31, 2010 Assets Liabilities and Stockholders' Equity Cash $4,000 Accounts payable $26,000 Accounts receivable 25,000 Dividends payable 17,000 Inventory 30,000 Rent payable 3,000 Prepaid Insurance 2,000 Stockholders' equity 40,000 Fixtures 25,000 Total assets $86,000 Total liabilities and equity $86,000 Actual and forecasted sales for selected...

  • Developing a Master Budget for a Merchandising Organization Peyton Department Store prepares budgets quarterly. The following...

    Developing a Master Budget for a Merchandising Organization Peyton Department Store prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for 2010. PEYTON DEPARTMENT STORE Balance Sheet March 31, 2010 Assets Liabilities and Stockholders' Equity Cash $3,000 Accounts payable $26,000 Accounts receivable 25,000 Dividends payable 17,000 Inventory 30,000 Rent payable 2,000 Prepaid Insurance 2,000 Stockholders' equity 40,000 Fixtures 25,000 Total assets $85,000 Total liabilities and equity $85,000 Actual and forecasted sales for selected...

  • You have just been hired as a new management trainee by Earrings Unlimited, a distributor of...

    You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting. you have decided to prepare a master budget for the upcoming second quarter. To this end, you have...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT