Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following data are information to assist in the preparation of a cash budget for the first quarter of 2020, Steam Co: Januarys sales for

The following data are information to assist in the preparation of a cash budget for the first quarter of 2020, Steam Co:

  1. Januarys sales for 2020 is 8.000 units, selling price is $250 per unit. The quantity to be sold in following month 20% more than the previous month. The selling price is always increase by 10% each month. 30% of total sales is cash sales and the remaining is sales on account. Collection pattern for credit sales is 40% in the month of sales, 25% in the following month, and 28% in the second month following the sales. The credit term of sales 2/10,n/30.
  2. Units sold in 2019 is 80% of total sales in next month. Unit selling price in 2019 is $200 per unit.
  3. Each month, the ending inventory exactly equals 60% of the cost of next months sales. The markup on goods is 25% of cost.
  4. Inventory purchases are paid for in the month following the purchase.
  5. Recurring monthly expenses are as follows:

Salaries and wages expense $250.000

Depreciation on plant and equipment $125.000

Utilities expenses $85.000

Others $15.000

  1. Property taxes of $122.000 are due and payable on February 15,2020.
  2. Advertising fees of $128.000 must be paid each month.
  3. Beginning cash balance per 1 January 2020 is $378.000.
  4. The company has a policy to maintain a minimum cash balance of $1.000.000. if necessary, it will borrow to meet its short term needs. All borrowing is done at the beginning of the month. All payments on principal and interest are made at the end of a month. The annual interest rate is 12%. The company must borrow in multiples of $10.000.

Instructions:

  1. Prepare a cash budget for January 2020.
  2. Is there any budgetary slack when to prepare a cash budget?

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

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

Principles Of Managerial Accounting

Authors: James M. Reeve

1st Edition

0324640625, 978-0324640625

More Books

Students also viewed these Accounting questions

Question

Describe the Indian constitution and political system.

Answered: 1 week ago

Question

Explain in detail the developing and developed economy of India

Answered: 1 week ago

Question

Problem: Evaluate the integral: I = X 52+7 - 1)(x+2) dx

Answered: 1 week ago

Question

What is gravity?

Answered: 1 week ago

Question

What is the Big Bang Theory?

Answered: 1 week ago

Question

2. Do you find change a. invigorating? b. stressful? _______

Answered: 1 week ago

Question

How was their resistance overcome?

Answered: 1 week ago