Monthly budget-supporting schedules

Assignment Help Basic Statistics
Reference no: EM1390605

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:

Sales for June-$141,000, July-$169,000, and August-$227,000

Manufacturing costs for June-59,000, July-73,000, and August -82,000

Selling and administrative expenses for June- 41,000, July-46,000, and Aug-50,000

Capital expenditures are zero in June and July and 54,000 in August.

The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% are expected to be collected in full in the month following the sale and the remainder the following month. Depreciation, insurance, and property tax expense represent $8,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in February, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month.

Current assets as of June 1 include cash of $54,000, marketable securities of $76,000, and accounts receivable of $168,200 ($123,000 from May sales and $45,200 from April sales). Sales on account in April and May were $113,000 and $123,000, respectively. Current liabilities as of June 1 include a $71,000, 12%, 90-day note payable due August 20 and $8,000 of accounts payable incurred in May for manufacturing costs.

All selling and administrative expenses are paid in cash in the period they are incurred. It is expected that $4,200 in dividends will be received in June. An estimated income tax payment of $20,000 will be made in July. Dash Shoes' regular quarterly dividend of $8,000 is expected to be declared in July and paid in August. Management desires to maintain a minimum cash balance of $42,000.

1. What are the estimated cash payments for manufacturing costs in June, July, and August?

2. On the basis of the cash budget prepared in part one, What recommendation should be made to the controller?

Reference no: EM1390605

Questions Cloud

Draw a two way anova design plot : Draw a two way ANOVA design plot (the mean plot you draw in class) to discuss whether there seems to be any interaction effects of gender and age.
Forecasting and quality control : A company is producing cylindrical blocks for a children's toy. The average diameter of a block is 3.5 inches. Sixteen blocks are inspected and the diameters are measured.
Explain the mode of inheritance controlling coat color : In cattle, coat color may be white, black, or black and white spotted. When true breeding white cattle are crossed with true-breeding black stock, the F1 is all solid white.
Determine the kinetic energy of the disk : A horizontal 797N merry-go-round is a solid disk of radius 1.53 m, started from rest by a steady horizontal force of 50.4 N applied tangentially to the edge of disk. Determine the kinetic energy of the disk after 3.06 s.
Monthly budget-supporting schedules : 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:
Sketch a free-body diagram of the plank : Sketch a free-body diagram of the plank. How far can a painter of mass 70.0 kg walk on the overhanging part of the plank before it tips.
Estimate the diameter of the field : If you analyze the diameter of the field of view for the 4X objective lens of a compound microscope with 10X oculars as 4.5 mm, what is the diameter of the field of view for the 100X objective lens?
Determine average net force exerted in the barrel of cannon : determine average net force exerted in the barrel of cannon.
Expected value of guessing : In multi-choice test, each question has four options. Students wil get 10 points for each correct answer; lose four points for each incorrect answer; and receive no points for unanswered questions.

Reviews

Write a Review

Basic Statistics Questions & Answers

  What is the probability a subscriber will spend for journal

The average time a subscriber spends reading the Wall Street Journal is 49 minutes. Assume that the standard deviation is 16 minutes and the time are normally distributed .

  Writing formal commentary of results of test

Based on this sample, is Moe correct in his assertion? Write up formal commentary of results of your test.

  Determining the point estimate

Determine the point estimate? Give the symbol and value.

  Probability of a type two error

Find the probability of a Type II error if in fact the mean waiting time is actually 9.8 minutes.

  X-bar and r chart

A Starbucks manager decides to study waiting times of customers for service at the lunch time rush hour 1100-1200. He observes three customers to measure the time the customer enters the line to the time he or she reaches the counter.

  Calculate the test statistic value for population mean

A sample of 81 business managers on the West Coast had an average breakfast cost of $7.65. 13. At a = 0.05, what is the test value?

  Repairers claim-standard deviation

You find that a random sample of five microwave ovens has a mean repair cost of $75 and a standard deviation of $12.50. At α = 0.01, do you have enough evidence to support the repairer's claim?

  Estimating the difference between the population means

Use a 5% significance level to test the claim that there appears to be a difference in the effectiveness of the two diets.

  Structuring the problem with decision tree

If the pilot plant fails, Rob feels the chance of the full-scale facility succeeding is only 20%. The probability that the pilot plant will succeed is estimated at 0.6. Structure this problem with a decision tree and advise Rob what to do.

  Finding p-value for specific level of significance

At the .05 level of significance, can we conclude that those joining Weight Reducers on average will lose less than 10 pounds? Determine the  p -value.

  Confidence interval for proportion of highly educated

Create a 95% confidence interval for proportion of highly educated women who left careers for family reasons and who wish to return to work.

  What two alues, symmetrically distributed around

The New York Times reported (L.J> Flynn, Tax Surfing, The New York Times, March 25, 2002, p. C10) that the mean time to download the home page for the internal Revenue Service (IRS) , was 0.8 second. Suppose that the download time was normally di..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd