Question
(a) The production department of Priston Company has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year. Year
(a) The production department of Priston Company has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year. Year Quarter 01 Quarter 02 Quarter 03 Quarter 04 Budgeted production 6,000 7,000 8,000 5,000 Each unit requires three pounds of raw material that costs $2.50 per pound. Management desires to end each quarter with a raw materials inventory equal to 20% of the following quarters production needs. The desired ending inventory for the 4th Quarter is 3,700 pounds. In addition, the beginning raw materials inventory for the 1st Quarter is budgeted to be 3,600 pounds. Requirements: (Marks 5) Prepare the companys direct materials purchase budget. At the bottom of your budget, show the dollar amount of purchases for each quarter.
(b) Peak sales for Midwest Products, a wholesale distributor of leaf rakes, occur in August. The companys sales budget for the third quarter showing these peak sales is given below: July August September Total Budgeted sales (on account) $600,000 $900,000 5,00,000 $2,000,000 From past experience, the company has learned that 20% of a months 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. Requirement: (Marks 5) Prepare a schedule of expected cash collections from sales, by month and in total, for the third quarter.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started