Purchase Solution

Dash Shoes Inc. Prepare a monthly cash budget

Not what you're looking for?

Ask Custom Question

The controller of Dash Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information:

June July August
Sales 120,000 150,000 200,000
Manufacturing costs 50,000 65,000 72,000
Selling & admin exp 35,000 40,000 45,000
Capital expenditures 48,000

INSTRUCTIONS:
1. Prepare a monthly cash budget and supporting schedules for June, July, and August 2010.
2. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?

Purchase this Solution
Solution Summary

You don't give me the traditional information about when the sales are collected and the expenses paid (the "stagger") so I will assume that all the cash receipts and payments are made in the same month as shown. See report in excel, attached, with ideas for the controller based on the $48,000 paid in June or July (can't tell from this which it is).

Solution Preview

You don't give me the traditional information about when the sales are collected and ...

Solution provided by:
Carol Sargent, PhD
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

View More Free Quizzes
Related BrainMass Solutions

  • Accounting - Monthly Budget and Supporting Schedules

    The controller of Dash Shoes Inc. instructs you to prepare a monthly cash budget for the next three months.

  • Cash Budget

    265656 Marine Tech, Inc: Prepare and analyze monthly cash budgets Please help with this problem in excel attached. Show all working in work format BM Accounting what the numbers mean 8th edition a.

  • Prepare a cash budget to help explain the lack of liquidity

    What calculations should he make to analyze the cash position of the company? Substantiate your answer by making the necessary calculations. 3. Should Carl prepare a quarterly or a monthly cash budget for McGovern Distributing Inc.?

  • Working Capital Management, EOQ, and External Funds

    Submit the results In a Microsoft Excel document showing all calculations, and in good form. Required: - Prepare a monthly cash budget for Capers Inc. covering the first 7 months of 2010.

  • Budget Creation

    532438 Budget Creation Marconi, Inc. a retailer of speciality paints, prepares a master budget. Data for the September master budget are given below. Prepare a balance sheet, an income statement and cash budget for September. a.

  • Managerial Accounting Problems Computed

    Prepare a schedule of expected cash disbursements for merchandise purchases for December. 3. Prepare a cash budget for December. Indicate in the financing section any borrowing that will be needed during the month.

  • appropriate controls to cover cash disbursements

    Usually, a senior person is selected so that the payments made remain within the budget of the department. This is a strong internal control on cash disbursements.

  • Cost Accounting Problems for Skanda, Inc.

    Prepare a segmented income statement for Skanda, Inc. b. Would closing the Shoes Department improve the company's net income? Explain.

  • Budgets and Income Statements

    Prepare a Cash Receipts Budget for the quarter ending June 30th, by month and quarter. You do not need a formal sales budget since the sales budget is above in the data. 2. Prepare a merchandise purchase budget by month and quarter.

View More Related Solutions