Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Level 3 Manufacturing Company expects to start January 1, 2022, with a cash balance of $70,000. Additional information for the cash budget covering 2022

image text in transcribed The Level 3 Manufacturing Company expects to start January 1, 2022, with a cash balance of $70,000. Additional information for the cash budget covering 2022 by quarters is as follows: Cash collections from customers: $120,000 in quarter 1, $140,000 in quarter 2, $150,000 in quarter 3, and $250,000 in quarter 4. Payments for purchases of direct materials: $54,000 in quarter 1, $60,000 in quarter 2, $65,000 in quarter3, and $75,000 in quarter 4. Payments for direct labor: $32,000 in quarter 1, $50,000 in quarter 2, $65,000 in quarter 3, and $70,000 in quarter 4. Manufacturing overhead (includes depreciation of $3,000): $33,000 in each quarter. Paid in the period incurred (except depreciation). Selling and administrative expenses (excludes depreciation): $14,000 in quarter 1, $15,000 in quarter 3, $15,000 in quarter 3 and $16,000 in quarter 4. Selling and administrative expenses are paid in the same period as incurred. The company will purchase and pay for a new computer system in the fourth quarter $20,000. The company has a line of credit at a financial institution that enables it to borrow up to $50,000. The company will borrow money at the beginning of a period when it needs money and repays borrowed money with accumulated interest at the end of the period when it has cash in excess of its minimum desired balance of $50,000. The annual interest rate on borrowed money is 6%. Required: 1. Prepare the cash budget for Level 3 Manufacturing for 2022. Show each quarter in a column, totals for the 4 quarters together are also required. Make sure you have a complete and accurate heading and use the appropriate labels. 2. Identify the cash balance that would be on the balance sheet as of December 31, 2022

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Managerial Accounting

Authors: Karen W. Braun, Wendy M. Tietz, Rhonda Pyper

2nd canadian edition

133025071, 978-0133519761, 133519767, 978-0133523676, 133523675, 978-0133025071

More Books

Students also viewed these Accounting questions

Question

Review the findings of humanistic psychotherapy outcome research.

Answered: 1 week ago

Question

Explain the importance of Human Resource Management

Answered: 1 week ago

Question

Discuss the scope of Human Resource Management

Answered: 1 week ago

Question

Discuss the different types of leadership

Answered: 1 week ago

Question

Write a note on Organisation manuals

Answered: 1 week ago

Question

Discuss the motives for expanding internationally LO2

Answered: 1 week ago