Other : BUS630 Ashford Wk 4 Managerial Accounting Activity-based Costing System

Address Question 1 by using a spreadsheet to prepare the case budget for the fourth quarter. The cash budget should be included as an appendix to the written report and should be referenced in the written report.

Address Question 2 in a fully developed explanation of two to four double spaced pages to present the findings and explain or validate the assumptions stated in item (a) through (c). In addressing Question 2, be sure to use the cash budget prepared in Question 1 as support for your explanation. The written analysis should be supported by at least two scholarly sources, excluding the textbook.

Week 4 Written Assignment should:

  • Demonstrate graduate level work including appropriate research and critical thinking skills.
  • Be presented as a written analysis (not a question/answer format).
  • Incorporate case questions into the overall analysis.
  • Follow APA formatting guidelines including title page, reference page and in-text citations.
  • Consists of two to four double-spaced pages of content.

Chester & Wayne is a regional food distribution company. Mr. Chester, CEO, has asked your assistance in preparing cash-flow information for the last three months of this year. Selected accounts from an interim balance sheet dated September 30, have the following balances:

Cash

Marketable securities Accounts receivable Inventories

$142,100 Accounts payable $354,155 200,000 Other payables 53,200

$1,012,500 150,388

Mr. Wayne, CFO, provides you with the following information based on experience and management policy. All sales are credit sales and are billed the last day of the month of sale. Customers paying within 10 days of the billing date may take a 2 percent cash discount. Forty percent of the sales is paid within the discount period in the month following billing. An additional 25 percent pays in the same month but does not receive the cash discount. Thirty percent is collected in the second month after billing; the remainder is uncollectible. Additional cash of $24,000 is expected in October from renting unused warehouse space.

Sixty percent of all purchases, selling and administrative expenses, and advertising expenses is paid in the month incurred. The remainder is paid in the following month. Ending inventory is set at 25 percent of the next month's budgeted cost of goods sold. The company's gross profit averages 30 percent of sales for the month. Selling and administrative expenses follow the formula of 5 percent of the current month's sales plus $75,000, which includes depreciation of $5,000. Advertising expenses are budgeted at 3 percent of sales.

Actual and budgeted sales information is as follows:

Actual:

August September

$750,000 787,500

Budgeted:

October November December January

$826,800 868,200 911,600 930,000

The company will acquire equipment costing $250,000 cash in November. Dividends of $45,000 will be paid in December.

The company would like to maintain a minimum cash balance at the end of each month of $120,000. Any excess amounts go first to repayment of short-term borrowings and then to investment in marketable securities. When cash is needed to reach the minimum balance, the company policy is to sell marketable securities before borrowing.

The company will acquire equipment costing $250,000 cash in November. Dividends of $45,000 will be paid in December.

The company would like to maintain a minimum cash balance at the end of each month of $120,000. Any excess amounts go first to repayment of short-term borrowings and then to investment in marketable securities. When cash is needed to reach the minimum balance, the company policy is to sell marketable securities before borrowing.

Questions (use of spreadsheet software is recommended):

1. Prepare a cash budget for each month of the fourth quarter and for the quarter in total. Prepare supporting schedules as needed. (Round all budget schedule amounts to the nearest dollar.)

2. You meet with Mr. Chester and Mr. Wayne to present your findings and happen to bring along your PC with the budget model software. They are worried about your findings in Part 1. They have obviously been arguing over certain assumptions you were given.

a. Mr. Wayne thinks that the gross margin may shrink to 27.5 percent because of higher purchase prices. He is concerned about what impact this will have on borrowings. Comment.

b. Mr. Chester thinks that "stock outs" occur too frequently and wants to see the impact of increasing inventory levels to 30 and 40 percent of next quarter's sales on their total investment. Comment on these changes.

c. Mr. Wayne wants to discontinue the cash discount for prompt payment. He thinks that maybe collections of an additional 20 percent of sales will be delayed from the month of billing to the next month. Mr. Chester says "That's ridiculous! We should increase the discount to 3 percent. Twenty percent more would be collected in the current month to get the higher discount." Comment on the cash- flow impacts.

Answers

Related Questions

How would you articulate why they are needed?...

 One of the attributes of a community leader is an ability to influence others toward some kind of action (e.g., join our coalition, give to our caus...

SCIENCE AND NURSING 3...

Running head: SCIENCE AND NURSING 1SCIENCE AND NURSING 3Science and NursingStudent NameUniversity NameSCIENCE AND NURSINGThe use of science is getting...

Explanation of the main purpose and scope of the c...

For this assignment you will continue to review current research from South’s Online Library and provide a critical evaluation on that research thro...

discuss about the importance of understanding the...

In previous weeks we have been reviewing the prevalence, mortality and morbidity associated with breast cancer. This is a topic of extreme public and...

Assess how you will handle a similar situation in...

Week 2 – Assignment Article Critique – Dealing with Annoying Co-WorkersRead the article entitled, How to deal with annoying co-workers (Links to...

Analyze how you handled this particular annoying c...

Week 2 – Assignment Article Critique – Dealing with Annoying Co-WorkersRead the article entitled, How to deal with annoying co-workers (Links to...

When reviewing the literature and different types...

Provide a 150 word answer to the following discussion question in apa format with in-text citations and references. Title page is not needed.Question:...

Explain the major differences between type 1 and t...

Please respond to this question. Be thorough and use the grading rubric to make sure your post is adequate.1- Explain the major differences between ty...

Discuss an encounter you have had with one of the...

Week 2 – Assignment Article Critique – Dealing with Annoying Co-WorkersRead the article entitled, How to deal with annoying co-workers (Links to...

Discuss key issues and perspectives regarding the...

Discuss key issues and perspectives regarding the field of psychologyThis writing assignment explores the various perspectives of psychology.A one and...

Describe what kinds of data tables or databases wo...

Consider the two (2) scenarios below, and then write a 1-2 page paper using proper spelling/grammar, addressing the items below each scenario.Scenario...

easy discussing the concept of Culturally Competen...

Read chapter 2 of the class textbook and review the attached PowerPoint presentation.  Once present a minimum of 1000 words easy discussing the conce...

What are the reasons for this trend?...

End-of-life care becomes an issue at some point for elderly clients.   Even with the emergence of palliative care programs and hospice   programs,...

Discuss work environment, level of accountability,...

Rubric: Student Provides relevant evidence of scholarly inquiry clearly stating how the evidence informed or changed professional or academic decision...

Explain how the social determinants of health may...

The Assignment: (1- to 2-page Global Health Comparison Matrix; 1-page Plan for Social Change)Part 1: Global Health Comparison MatrixFocusing on the co...

Prepare a 1,000...

Research a health care organization or a network that spans several states within the U.S. (Example: United Healthcare, Vanguard, Banner Healthcare, e...

Discuss the prevalence of each of these health pro...

For the middle-aged adult, exercise can reduce the risk of various health problems. Choose two at-risk health issues that regular physical exercise an...

Review the standards of practice related to your c...

At some point in every construction project, efforts turn from design and the focus moves to actual construction. With the vision in place and the too...

If you talk about a possible poor health outcome,...

If you talk about a possible poor health outcome, do you believe that outcome will occur? Do you believe eye contact and personal contact should be av...

Conduct in...

By the due date assigned, submit your assignment to the Submissions Area.Conduct in-depth analysis of a pertinent topic related to aging. Define the p...

Community Teaching Plan: Teaching Experience Paper...

The RN to BSN program at Grand Canyon University meets the requirements for clinical competencies as defined by the Commission on Collegiate Nursing E...

Lab: Introduction to the Night Sky with Stellarium...

PHY 121: The Solar System Name_______________________________Portland Community CollegeGrade = _______/20 = _______%Lab: Introduction to the Night Sky...

Have you ever printed a photograph to find that th...

Week 6 Discussion Question:Light and Colors.Have you ever printed a photograph to find that the print’s colors were not the same as shown on the com...

how is a spacecraft launched, what is magnet...

Individual research work (10 Points):Knowing you as a physics student, one of your friends ask you a question about physical science.  Give your best...

If you didn't find the right answer

Ask Your Questions, We'll notify you once someone answers it