Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

We are in the year 2021 again. Mask Manufacturing produces and sells non-medical masks. Their masks sell for $5.75 each. Total quantity of masks on

We are in the year 2021 again.  Mask Manufacturing produces and sells non-medical masks.  Their masks sell for $5.75 each.  Total quantity of masks on hand as of January 1 were 15,000.  Goal is to have 25% of next month's sales on hand at the end of each month.  First quarter sales are below.  April and May sales are forecast to be 60,000 units each month.  Last year:  November and December sales were $200,000 each month.  Other information:                           

-         Sales are 25% cash and 75% on credit.  Of the credit sales, collections are forecast at:  25% current month, 50% following month, and 25% the 2nd following month. 

-         Production cost for masks is $4.00 each ($1.50 for labour, $1.50 for materials and $1.00 for overhead).  Labour is paid in the current month.  Materials are purchased in the month they are used, and paid in the following month.  Overhead expenses are paid in the current month.

-         The company must make a one-time payment of $50,000 in February for royalties. 

-         Management requires a minimum cash balance of $25,000. 


a) Do a production budget for each of the first 3 months of 2021.  (5 marks)

b) Do a schedule of cash receipts for each of the first 3 months of 2021.  (7 marks)

c) Do a cash flow forecast for each of the first 3 months of 2021. Include short-term borrowing if required. (8 marks)                                                            

You may choose to combine parts b) and c) if you wish.                                                                

                                                                       

Budgeted volumes for 2021                              Jan            Feb           Mar          April

Sales - Units                                                      60,000       40,000     50,000      60,000

Step by Step Solution

3.30 Rating (147 Votes )

There are 3 Steps involved in it

Step: 1

Solution Mask Manufacturing Production Budget for each of the three months of 2021 Schedule of cash ... 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

Step: 3

blur-text-image

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

Managerial Accounting

Authors: Karen W. Braun, Wendy M. Tietz

4th edition

978-0133428469, 013342846X, 133428370, 978-0133428377

More Books

Students also viewed these Finance questions