Question

In: Accounting

Rainy Day Company The Business Situation Rainy Day Company manufactures a unique umbrella. The company began...

Rainy Day Company

The Business Situation

Rainy Day Company manufactures a unique umbrella. The company began operations April 1, 2020. Its accountant quit the second week of operations, and the company is searching for a replacement. The company has decided to test the knowledge and ability of all candidates interviewing for the position. Each candidate will be provided with the information below and then asked to prepare a series of reports, schedules, budgets, and recommendations based on that information. The information provided to each candidate is as follows.

Cost Items and Account Balances

Administrative salaries                                   $11,250

Advertising                                                     15,250

Cash, April 1                                            –0–

Depreciation on factory building                       1,500

Depreciation on office equipment                        800

Insurance on factory building                             1,500

Miscellaneous expenses—factory                      1,000

Office supplies expense                                         300

Professional fees                                                    500

Property taxes on factory building                        400

Raw materials used                                          70,000

Rent on production equipment                         6,000

Research and development                             10,000

Sales commissions                                            40,000

Utility costs—factory                                             900

Wages—factory                                                70,000

Work in process, April 1                         –0–

Work in process, April 30                       –0–

Raw materials inventory, April 1            –0–

Raw materials inventory, April 30         –0–

Raw material purchases                                   70,000

Finished goods inventory, April 1           –0–

Production and Sales Data

Number of umbrellas produced                     10,000

Expected sales in units for April

($40 unit sales price)                                       8,000

Expected sales in units for May                      10,000

Desired ending inventory                               20% of next month’s sales

Direct materials per finished unit                  1 kilogram

Direct materials cost                                       $7 per kilogram

Direct labor hours per unit                             .35

Direct labor hourly rate                                  $20

Cash Flow Data

Cash collections from customers: 75% in month of sale and 25% the following month.

Cash payments to suppliers: 75% in month of purchase and 25% the following month.

Income tax rate: 45%.

Cost of proposed production equipment: $720,000.

Manufacturing overhead and selling and administrative costs are paid as incurred.

Desired ending cash balance: $30,000.

9. Calculate the break-even point in units and in sales dollars.

10. Prepare the following budgets for the month of April 2020.

(a) Sales.

(b) Production.

(c) Direct materials.

(d) Direct labor.

(e) Selling and administrative expenses.

(f) Cash.

(g) Budgeted income statement.

11. Prepare a flexible budget for manufacturing costs for activity levels between 8,000 and

10,000 units, in 1,000-unit increments.

12. Identify one potential cause of direct materials, direct labor, and manufacturing overhead variances in the production of the umbrella.

13. Determine the cash payback period on the proposed production equipment purchase, assuming a monthly cash flow as indicated in the cash budget (requirement 10f).

Solutions

Expert Solution

9. Total variable costs per unit = Direct Materials + Direct Labor + Sales Commission = 1 kg. x $ 7 + 0.35 hours x $ 20 + $ 5= $ 19

Contribution margin per unit = Selling price - Variable costs = $ 40 - $ 19 = $ 21

Total fixed cost = $ 49,400

Break-even number of units = $ 49,400 / $ 21 = 2,352.38 units

Breakeven sales dolars = 2,352.38 units x $ 40 = $ 94,095.24

10.a.

Sales Budget
April May Total
Unit Sales 8,000 10,000 18,000
Selling price per unit $ 40 $ 40 $ 40
Budgeted sales revenue $ 320,000 $ 400,000 $ 720,000

b.

Production Budget
April May Total
Unit sales 8,000 10,000 18,000
Add: Desired ending invetory 2,000
Total finished goods needed 10,000
Less: Beginning inventory 0
Required production in units 10,000

c.

Direct Materials Budget
April
Required production in units 10,000
Qty required per unit 1 kg.
Total direct materials used in production 10,000 kgs.
Add: Desired ending inventory 0
Total inventory needed 10,000 kgs.
Less: Beginning inventory 0
Direct materials to be purchased 10,000 kgs
Cost per kg. $ 7
Budgeted cost of direct materials purchases $ 70,000

d.

Direct Labor Budget
April
Budgeted production in units 10,000
Direct labor hours per unit 0.35
Direct labor hours required 3,500 hrs
Direct labor hour rate $ 20
Budgeted cost of direct labor $ 70,000

e.

Selling and Administrative Expenses Budget
April
Advertising expense $ 15,250
Sales Commission 40,000
Administrative salaries 11,250
Office Supplies Expense 300
Professional Fees 500
Research and development 10,000
Total cash expenses 77,300
Depreciation on office equipment 800
Total budgeted selling and administrative expenses 78,100

f.

Cash Budget
For April 2020
Beginning cash balance $ 0
Ad: Cash receipts 240,000
Total cash available 240,000
Less: Cash disbursements for
Purchase of direct materials $ 52,500
Direct labor 70,000
Manufacturing overhead 9,800
Selling and administrative expenses 77,300
Purchase of equipment 720,000
Total cash disbursements 929,600
Cash Surplus( Deficiency) (689,600)
Borrowing 719,600
Ending cash balance $ 30,000

g.

Income Statement
For the month ended April 30, 2020
Sales $ 320,000
Cost of Goods Sold
Direct materials $ 70,000
Direct labor 70,000
Manufacturing overhead 11,300
Cost of goods manufactured 151,300
Add: Beginning finished goods inventory 0
Cost of goods available for sale 151,300
Less: Ending finished goods inventory (30,260) 121,040
Gross Margin 198,960
Selling and Administrative Expenses 78,100
Income from Operations 120,860
Income taxes @ 45 % 54,387
Net income $ 66,473

Related Solutions

Rainy Day Company The Business Situation Rainy Day Company manufactures a unique umbrella. The company began...
Rainy Day Company The Business Situation Rainy Day Company manufactures a unique umbrella. The company began operations April 1, 2020. Its accountant quit the second week of operations, and the company is searching for a replacement. The company has decided to test the knowledge and ability of all candidates interviewing for the position. Each candidate will be provided with the information below and then asked to prepare a series of reports, schedules, budgets, and recommendations based on that information. The...
Rainy Day Company The Business Situation Rainy Day Company manufactures a unique umbrella. The company began...
Rainy Day Company The Business Situation Rainy Day Company manufactures a unique umbrella. The company began operations April 1, 2020. Its accountant quit the second week of operations, and the company is searching for a replacement. The company has decided to test the knowledge and ability of all candidates interviewing for the position. Each candidate will be provided with the information below and then asked to prepare a series of reports, schedules, budgets, and recommendations based on that information. The...
Rainy Day Company manufactures a unique umbrella. The company began operations April 1, 2020. Its accountant...
Rainy Day Company manufactures a unique umbrella. The company began operations April 1, 2020. Its accountant quit the second week of operations, and the company is searching for a replacement. The company has decided to test the knowledge and ability of all candidates interviewing for the position. Each candidate will be provided with the information below and then asked to prepare a series of reports, schedules, budgets, and recommendations based on that information. The information provided to each candidate is...
Rainy Day Company manufactures a unique umbrella. The company began operations April 1, 2020. Its accountant...
Rainy Day Company manufactures a unique umbrella. The company began operations April 1, 2020. Its accountant quit the second week of operations, and the company is searching for a replacement. The company has decided to test the knowledge and ability of all candidates interviewing for the position. Each candidate will be provided with the information below and then asked to prepare a series of reports, schedules, budgets, and recommendations based on that information. The information provided to each candidate is...
Rainy Day Company manufactures a unique umbrella. The company began operations April 1, 2020. Its accountant...
Rainy Day Company manufactures a unique umbrella. The company began operations April 1, 2020. Its accountant quit the second week of operations, and the company is searching for a replacement. The company has decided to test the knowledge and ability of all candidates interviewing for the position. Each candidate will be provided with the information below and then asked to prepare a series of reports, schedules, budgets, and recommendations based on that information. The information provided to each candidate is...
Rainy Day Company manufactures a unique umbrella. The company began operations April 1, 2020. Its accountant...
Rainy Day Company manufactures a unique umbrella. The company began operations April 1, 2020. Its accountant quit the second week of operations, and the company is searching for a replacement. The company has decided to test the knowledge and ability of all candidates interviewing for the position. Each candidate will be provided with the information below and then asked to prepare a series of reports, schedules, budgets, and recommendations based on that information. The information provided to each candidate is...
Namaste Company The Business Situation Namaste Company manufactures a unique yoga mat. The company began operations...
Namaste Company The Business Situation Namaste Company manufactures a unique yoga mat. The company began operations December 1, 2018. Its accountant quit the second week of operations, and the company is searching for a replacement. The company has decided to test the knowledge and ability of all candidates interviewing for the position. Each candidate will be provided with the information below and then asked to prepare a series of reports, schedules, budgets, and recommendations based on that information. The information...
Namaste Company The Business Situation Namaste Company manufactures a unique yoga mat. The company began operations...
Namaste Company The Business Situation Namaste Company manufactures a unique yoga mat. The company began operations December 1, 2018. Its accountant quit the second week of operations, and the company is searching for a replacement. The company has decided to test the knowledge and ability of all candidates interviewing for the position. Each candidate will be provided with the information below and then asked to prepare a series of reports, schedules, budgets, and recommendations based on that information. The information...
The Business Situation Namaste Company manufactures a unique yoga mat.  The company began operations December 1, 2018....
The Business Situation Namaste Company manufactures a unique yoga mat.  The company began operations December 1, 2018. Its accountant quit the second week of operations, and the company is searching for a replacement. The company has decided to test the knowledge and ability of all candidates interviewing for the position. Each candidate will be provided with the information below and then asked to prepare a series of reports, schedules, budgets, and recommendations based on that information. The information provided to each...
The Business Situation Namaste Company manufactures a unique yoga mat.  The company began operations December 1, 2018....
The Business Situation Namaste Company manufactures a unique yoga mat.  The company began operations December 1, 2018. Its accountant quit the second week of operations, and the company is searching for a replacement. The company has decided to test the knowledge and ability of all candidates interviewing for the position. Each candidate will be provided with the information below and then asked to prepare a series of reports, schedules, budgets, and recommendations based on that information. The information provided to each...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT