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

  Probability through conditional probability

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

  Statistical quality control-r-chart-xbar-chart

The Awake Coffee Company produces gourmet instant coffee. The company wants to be sure that the average fill of coffee containers is 12.0 ounces.

  Summarize data by computing the means and standard deviation

College Students' Seating Choices and Motivation to Achieve.This activity is a revision of an activity found in Real Data: A Statistics Workbook Based on Empirical Data by Z. C Holcomb (1997). Published by Pyrczak Publishing.

  Computing z-score for advertising time

You listen to radio station for 1 hour, at arbitrarily selected time, and carefully observe that amount of advertising time is equal to 7 minutes. Compute z-score for this amount of advertising time.

  Determining essential sample size for health insurance

Jolly Blue Giant Health Insurance is concerned about rising lab test costs and would like to know. Determine the essential sample size?

  Satisfaction rating for the gaming console

Letting μ be the mean composite satisfaction rating for the gaming console, we find that the test should be H o : μ ≤ 42 versus H a :  μ > 42

  Level of significance-receiving lower grades

Using a level of significance of .05, is there evidence that the dual degree students are receiving lower grades? Explain.

  Estimate the pearson correlation coefficient

Explain the logic of what you have done, writing as if you are speaking to someone who has never heard of correlation (but who does understand the mean, deviation scores, and hypothesis testing);

  Determining number of vehicles passing from one point

Determine expectation of number of vehicles passing through this specified point in ten minutes.

  Trucks significantly having lower accident rate

Test the proportions of yellow fire trucks have a significantly lower accident rate.

  Random sample of five accidents

A random sample of five accidents resulted in the following number of persons injured: 18, 15, 12, 19, & 21. Using the .01 significance level, can we conclude the population mean is less than 20 for all accidents?

  Forcast the proportion of fish in a perticular lake

A researcher wishes to forcast the proportion of fish in a perticular lake which is inedible due to pollution of the lake.

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