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

technical writing...

   you must email me before noon on Monday and inform me what object you’ll be building for this assignment.  Should any of you need Legos to com...

research the various elements of the marketing pla...

Marketing Plan This week you will continue your comprehensive marketing plan researching the SAME company that you researched in Unit I. Again, utiliz...

Assignment for Professional Communication - Teleph...

Hello There I need to do an assignment for professional communication related to telephone voicemail. In attached it is the instruction to follow ca...

Any Statistic gurus? This is from the Lane St...

62. Suppose that the distance of fly balls hit to the outfield (in baseball) is normally distributed with a mean of 250 feet and a standard deviation...

Ethical Theories Essay...

According to Ethics for Life: A Text with Readings, there are two main types of ethical theories--noncognitive and cognitive theories. Cognitive theo...

1. What kind of decisions has chief executive Ben...

1. What kind of decisions has chief executive Ben Verwaayen been making at Alcatel-Lucent? 2. To what extent are these decisions subject to risk and...

1. Either alone or in a group, think about the eth...

1. Either alone or in a group, think about the ethical implications of extreme decision making by groups 2. When group decision making takes place, s...

As a group, spend 5 or 10 minutes generating ideas...

As a group, spend 5 or 10 minutes generating ideas about the alternative restaurants that the members think will be most likely to succeed. Each group...

Having answered the previous five questions,, do y...

Having answered the previous five questions,, do you think in retrospect that you made a reasonable decision? What, if anything, might you do to impro...

Try to remember how you reached the decision....

Try to remember how you reached the decision. Did you sit down and consciously think through the implications of each alternative, or did you make a d...

Think about an organization in your local communit...

Think about an organization in your local community or your university, or an organization’s that you are familiar with, that is doing poorly. Now t...

1. What forces in the global environment are leadi...

1. What forces in the global environment are leading to outsourcing? 2. What has outsourcing meant to countries like India? 3. Do you think outsourc...

1. What kinds of advantages can Chinese companies...

1. What kinds of advantages can Chinese companies obtain if they move production into the United States? 2. What are some possible disadvantages and...

1. Analyze the major forces in the task environmen...

1. Analyze the major forces in the task environment of a retail clothing store. 2. Devise a program that will help other managers and employees to be...

1. Either by yourself or in a group, discuss if it...

1. Either by yourself or in a group, discuss if it is ethical to employ children in factories, and whether U.S. companies should buy and sell products...

Choose an organization, and ask a manager in that...

Choose an organization, and ask a manager in that organization to list the number and strengths of forces in the organization’s task environment. As...

Following the passage of the North American Free T...

Following the passage of the North American Free Trade Agreement, many U.S. companies shifted production operations to Mexico to take advantage of low...

How do political, legal, and economic forces shape...

How do political, legal, and economic forces shape national culture? What characteristics of national culture do you think have the most important eff...

The population is aging because of a combination o...

The population is aging because of a combination of declining birth rates, declining death rates, and the aging of the baby boom generation. What migh...

1. What was the impetus for the union organizing e...

1. What was the impetus for the union organizing effort at SGA Mills? 2. Discuss SGA’s strategy in managing the representation campaign? 3. Discus...

1. Did Helen’s actions invade James’ right to...

1. Did Helen’s actions invade James’ right to privacy? 2. Was the company justified in suspending James? 3. What should be the key contents of a...

1. What action do you believe Eastern State Univer...

1. What action do you believe Eastern State University should have taken with regard to Paul Lewis? Do you agree with the dean’s solution to the pro...

1. In this particular case, was the company guilty...

1. In this particular case, was the company guilty or innocent of safety violations which resulted in the death of Mr. Carlson? 2. Irrespective of th...

1. What are the advantages and disadvantages of ex...

1. What are the advantages and disadvantages of extending Maura Currier’s leave? 2. If you were the Human Resources Director, would you grant Maura...

If you didn't find the right answer

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