Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

In this mini-case, you will be doing the same analysis but using information a seasonal production schedule. With a seasonal production schedule, the company

 

In this mini-case, you will be doing the same analysis but using information a seasonal production schedule. With a seasonal production schedule, the company will ONLY produce the same amount of units they are projecting to sell each month. Seasonal Products Corporation expects the following monthly sales: $20,000 $15,000 $5,000 January February March April May June $3,000 $1,000 $3,000 July August September October November December $10,000 $14,000 $20,000 $25,000 $30,000 $22,000 Sales are 20% cash in a given month, with the remainder going into accounts receivable. All 80% of the credit sales are collected in the month following the sale. Seasonal Products Corporation sells all its units for $2 each and produces them for $1. Seasonal Products Corporation matches their production schedule to the projected level of sales. For example, if they are expecting to sell 10,000 units in a month, they only produce 10,000 units. a) Generate a monthly production and inventory schedule in units. Beginning inventory in January is 0 units. (Note: in part a) you should work in terms of units of production and units of sales) b) Determine a cash receipts schedule for January through December. Assume dollar sales in December were $15,000. Work using dollars. c) Determine a cash payments schedule for January through December. The production costs ($1 per unit produced) are paid in the month in which they occur. Other cash payments, besides those for production costs, are $7,000 per month for the seasonal production. d) Construct a cash budget for January through December. The beginning cash balance is $1,000, and that is also the required monthly minimum.

Step by Step Solution

3.33 Rating (150 Votes )

There are 3 Steps involved in it

Step: 1

a Monthly Production and Inventory Schedule in Units To generate the monthly production and inventory schedule in units we will match the production schedule to the projected level of sales The beginn... blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students explore these related Finance questions