Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the info from problems # 1 and | | 6 , calculate the Cost of Goods Sold Budget for Jan, Feb, & March. In

Using the info from problems #1 and ||6, calculate the Cost of Goods Sold
Budget for Jan, Feb, & March.
In addition to the info in problem H1, the following cost behavior
patterns are budgeted for the operating expenses each month:
Fixed Costs: $10,000 Admin Salaries, $5,000 Depreciation, $2,000 Advertising
Variable Costs per unit sold: $3 Sales Cornmissions, $1 supplies, $2 Marketing
Mixed Costs! Utilities $3,000 plus $2 per unit sold
Prepare the Operating Expense Budget for Jan, Feb & March.
Using the info from the previous 6 problems, prepare an Income Statement
in good format for Jan, Feb, & March, and for the Total Quarter 11?18+331?18.
Also calculate the Gross Margin Ratio for the quarter ending 3/31/18.
In addition to the info in problem 11, and based on past experience, the
company expects to collect 85% of the month's sales in the current month,
and 15% in the month following the sale. The accounts recelvable balance
at 1231?17 was $50,000 and is deemed fully collectible.
Prepare the Cash Receipts Budget for Jan, Feb, & March.
Also calculate the Accounts Receivable balance on 3/31/18.
In addition to the info from previous problems, the following cash
disbursements were made each month:
Equipment purchases $50,000 in Jan, $24,950 in Feb, & $30,000 in March.
Dividends paid of $35,000 in Jan, $20,000 in Feb and $15,000 in March.
Materials purchases are paid for 100% in the month of purchase.
Operating expenses include $5,000 of Depreciation each month, which is a
non-cash expense.
Prepare the Cash Disbursements Budget for Jan, Feb, & March, which should also
include the cash payments for materials, labor, MOH, and operating expenses.
The bank requires a minimum cash balance at the end of each month of $50,000.
The company has a $500,000 line of credit with $0 outstanding balance as of 11?18.
Interest on the line of credit is 12% annually, and is paid at the end of each month.
Ending cash balance on 1231?17 was $52,500.
In addition to the info in problems $10 and $11, prepare a Comprehensive Cash
Budget for Jan, Feb, and March.
In addition to the info from problems $10 & #12, the following balances are as of 331?18 :
Equipment, net of Accum. Deprec. =$289,000
Bonds Payable =$145,000(one annual payment in July)
Beginning Retained Earnings Bal 11?18=$93,000
Common Stock =$210,000
Prepare a Balance Sheet in good format as of 331?18.
image text in transcribed

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

Auditing and Assurance services an integrated approach

Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley, Chris E. Hogan

16th edition

978-0134075754, 134075757, 134065824, 978-0134065823

More Books

Students also viewed these Accounting questions

Question

What is the function of the CompareIt feature in Checkpoint?

Answered: 1 week ago

Question

Recognize the features of practical performance appraisal forms

Answered: 1 week ago