Purchase Solution

Midwest Products

Not what you're looking for?

Ask Custom Question

See attached problem regarding budget and expected cash collections.

Exercise 9-1 Schedule of Expected Cash Collections
Peak sales for Midwest Products, a wholesale distributor of leaf rakes, occur in August. The company's sales budget for the third quarter showing these peak sales is given below:

July August Sep.
Budgeted sales (all on account) 600,000 900,000 500,000

From past experience, the company has learned that 20% of a month's sales are collected in the month of sale, another 70% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. Bad debts are negligible and can be ignored. May sales totaled $430,000, and June sales totaled $540,000.

Required:
1. Prepare a schedule of expected cash collections from sales, by month and in total, for the third quarter.

2. Assume that the company will prepare a budgeted balance sheet as of September 30. Compute the accounts receivable as of that date.

Attachments
Purchase this Solution
Solution Summary

This solution is comprised of a detailed explanation to prepare a schedule of expected cash collections from sales, by month and in total, for the third quarter and compute the accounts receivable assume that the company will prepare a budgeted balance sheet as of September 30.

Solution Preview

Exercise 9-1 Schedule of Expected Cash Collections
Peak sales for Midwest Products, a wholesale distributor of leaf rakes, occur in August. The company's sales budget for the third quarter showing these peak sales is given below:

July August Sep.
Budgeted sales (all on account) 600,000 900,000 500,000

From past ...

Purchase this Solution
Free BrainMass Quizzes
Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Motivation

This tests some key elements of major motivation theories.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

View More Free Quizzes
Related BrainMass Solutions

  • Midwest Ice Cream Company

    Since Midwest has six products, the mix of products sold also affect profit variance.

  • Multiple Regression

    Question 4 : The file Q4Data.xlscontains sales data (in thousands of $) for a medical supplies company that sells its products in three regions South (coded 1), West (coded 2) and Midwest (coded 3).

  • Leadership and Ethical Decision-Making at Midwest Valueland

    Scenario: Midwest Valueland (MV) is a regional superstore chain of 200 stores located throughout the Midwest states in convenient suburban locations.

  • Statistics - Probability Access Northeast Midwest South West

    (1) P(South or Midwest or Yes) = P(South) + P(Midwest) + P(Yes) - P(South and Midwest) - P(Midwest and Yes) - P(South and Yes) + P(South and Midwest and Yes) = 20.7/60 + 14.1/60 + 50.6/60 - 0 - 11.8/60 - 16.9/60 + 0 = 0.945 (2) P(Male

  • Peak sales for Midwest Products

    Exercise 9-1 Schedule of Expected Cash Collections [LO2] Peak sales for Midwest Products, a wholesale distributor of leaf rakes, occur in August.

  • Confidence Interval: Proportion of Customers' Orders

    MidWest Other Male Low 2 $55.39 $42.59 02-Apr Sun Afternoon West Other Female High 4 $206.39 $112.57 03-Apr Tues Morning MidWest Other Female High 4 $245.67 $73.18 03-Apr Tues Morning NorthEast Other Female High 5 $265.69 $87.40 03-Apr Tues

  • Marketing Plan: Chocolate Bliss Carob

    According to Statista (statista 2022), Chocolate Bliss' target expansion site - the US Midwest, consumes about 24% of the chocolate products sold in America each year.

  • Contract cancellation letter

    PolicyPlan has engaged Midwest Sparkleen for interior and exterior cleaning for the past five years. Midwest Sparkleen did exemplary work for the first four years, but after a change of ownership last year, the level of service has plummeted.

  • MAT - 540 Quantitaive Methids

    The Livewright Medical Supplies Company has a total of 12 salespeople it wants to assign to three regions - the South, the east, and the Midwest.

View More Related Solutions