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

  Average wait for each passenger

The number of passengers arriving at an airport terminal average 1200 each hour. To process passengers (check in, take luggage, etc) take an average of 6 minutes each. There are 6 airport staffers processing passengers. How long is the average wai..

  Sampling distribution of the average score

The sampling distribution of the average score and Suppose x' is your average pay for the 100 weeks. Then x' has approximately

  Evaluate the slope of the least-squares regression line

If we fit the least-squares line to the 12 data points (one for each month) we obtain the following results from a software package. Notice that temperature is taken as the explanatory variable and crawling age as the response.

  First part of this theorem allows a problem solver

First part of this theorem allows a problem solver to compute probabilities about sample means regardless of whether a population is normally distributed.

  Probability that a randomly selected student will pas exam

Students need a score of 60 points to pass the exam. What is the probability that a randomly selected student will pas the exam? (P(X ≥ 60))

  Probability through conditional probability

Given that both balls selected are white what is the probability that bowl 3 was selected?

  Determining probability of marks on statistics midterm

Marks on statistics midterm test are normally distributed with mean of 78 and a standard deviation of 6. Determine the probability that class of 50 has average midterm mark that is less than 75?

  Increases expected number of credits by regression equation

Regression equation Credits=15.4-.07. Select the correct statement. Increase in number of hours worked per week increases the expected number of credits.

  Probability value based on log normal distribution

What is the expected number of customers that will have to wait more than 6 hours?

  Question based on multiple regression

Multiple choice question based on multiple regression - The coefficient of determination for this model is

  Testing difference between two population means

Do the thinner cans appear to be strong enough so that they are not crushed when the top lids are pressed onto the sides?

  Normalized matrix for one decision criterion

Normalized matrix for one decision criterion at Firm T is given below.

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