Prepare a flexible budget and a performance report

Assignment Help Accounting Basics
Reference no: EM132012556

Problem - You are the Assistant Controller for the RJC Corporation and have been given the responsibility for formulating the budget for the upcoming year. The RJC Corporation is experiencing a period of rapid expansion, so production planning, inventory levels and cash flow will be exceedingly important.

The following information will be used to prepare the budget:

1. RJC Corporation has experienced an excellent record in accounts receivable collection and expects this trend to continue. Sixty percent of billings are collected in the month after the sale and 40% in the second month after the sale. Uncollectible accounts are minimal and can be ignored in your analysis.

2. The purchase of parts is RJC Corporation's largest expenditure: The cost of these items is equal to 50% of sales. Sixty percent of these parts are received one month prior to sale and 40% are received during the month of sale.

3. Eighty percent of accounts payable have been paid one month after receipt of purchases and the remaining 20% have been paid two months after receipt.

4. Wages, including fringe benefits, are a function of sales volume and are equal to 20% of the current month's sales. These wages are paid in the month incurred.

5. General and administrative expenses include:

A. $480,000 in salaries

B. Product promotions, 3% of Sales

C. $240,000 in property taxes

D. $360,000 for insurance

E. $300,000 in utilities

F. $600,000 in depreciation

G. Workers Compensation Insurance, 1.5% of Direct Labor

All expenses except property taxes, Product Promotions and Workers Compensation Insurance are incurred uniformly throughout the year. Property taxes are paid in four equal installments in the last month of each calendar quarter.

6. The company makes income tax payments in the first month of each quarter based on the income for the prior quarter. The company is subject to an effective income tax rate of 40%. The pretax income for the last quarter of this year is projected to be $612,000.

7. Factory overhead is a function of the cost of Direct Labor, and is predetermined at 85%,

Required:

A. Prepare the spreadsheets from the templates with the necessary figures.

B. Sales for June were 90% of budgeted. Prepare a flexible budget and a performance report for the month of June.

C. Sales for each month are listed below

November

1,798,500.00

July

3,270,000.00

December

1,853,000.00

August

3,270,000.00

January

1,962,000.00

September

3,488,000.00

February

2,180,000.00

October

3,488,000.00

March

1,962,000.00

November

3,270,000.00

April

2,398,000.00

December

3,706,000.00

May

2,725,000.00

January

3,597,000.00

June

3,052,000.00



Reference no: EM132012556

Questions Cloud

What is the present? value : Find the present value of an ordinary annuity with deposits of ?$15,238 every 6 months 3 years at 7.2?% compounded semiannually
How you identify as a human and social services professional : Post an explanation of how you identify as a human and social services professional (e.g., social worker, gerontology aid, administrator, probation officer).
What is speculative value implied by observed market price : The required return is 10%. What is the speculative value implied by the observed market price?
Find the present value of an ordinary annuity : Find the present value of an ordinary annuity which has payments of? $2100 per year for 16 years at 8?% compounded annually.
Prepare a flexible budget and a performance report : Sales for June were 90% of budgeted. Prepare a flexible budget and a performance report for the month of June
Ordinary annuity for a comparable rate of? return : He promptly sold it for ?$186,916. What annual interest rate would he need to earn on an ordinary annuity for a comparable rate of? return?
Explain how that particular display helps us understand : There are many tools that take vast arrays of data and create information in a form that helps us better understand what the data tells us.
Liquidity management and capital adequacy management : Explain the following bank management activities: liquidity management, asset management, liquidity management, capital adequacy management,
Design and produce a poster advertising : SIT60316 - BSBITU306 - Advanced Diploma of Hospitality Management - Design and produce business documents - Business Portfolio

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd