Prepare a sales budget and cash receipts budget

Assignment Help Managerial Accounting
Reference no: EM131696113

Chika Company manufactures and sells a product that has seasonal variations in demand, with peak sales coming in the third quarter. She has just completed her first year of business and is beginning to budget for Year 2.

The following information is what she has developed in order to finish her budget:

a. The company's product sells for $8 per unit. Budgeted sales for the next six quarters are as follows:

Budgeted sales in units: Qtr 1: 40,000 Qtr 2: 60,000 Qtr 3: 100,000 Qtr 4: 50,000 Year 3-Qtr 1: 70,000, Qtr 2: 80,000

b. Sales are collected in the following pattern. 75% in the quarter the sales are made, and the remaining 25% the following quarter. On January 1, Year 2, the company's balance sheet showed $65,000 in accounts receivable, all of which will be collected in the first quarter of the year. Bad debts are considered negligible and can be ignored.

c. The company desires an ending inventory of finished units on hand at the end of each quarter equal to 30% of the budgeted sales for the next quarter. On December 31, Year 1, the company had 12,000 units on hand.

d. Five pounds of raw materials are required to complete one unit of product. The company requires an ending inventory of raw materials on hand at the end of each quarter equal to 10% of the production needs of the following quarter. On December 31, Year 1, the company had 23,000 pounds of raw materials on hand. (HINT: USE YOUR PURCHASES BUDGET x 5!!)

e. The raw material costs .80 per pound. Purchases of raw materials are paid for in the following pattern: 60% paid in the quarter the purchase was made, and the remaining 40% paid in the following quarter. On January 1, Year 2, the company's balance sheet showed $81,500 in accounts payable for raw materials purchases, all of which will be paid in the first quarter of the year. (HINT: THIS IS WHAT OUR CASH DISBURSEMENTS ARE BASED ON!!)

f. Other expenses include:
Salaries: $3,000 per month
Advertising: $1,000 per month
Depreciation $500 per month
Taxes: $200 per month accrued, paid annually in October

Prepare a sales budget, cash receipts budget, production budget, raw materials budget, and cash disbursements budget.

Reference no: EM131696113

Questions Cloud

Cost leadership or benefit leadership : 1. A firm can outperform its rivals through cost leadership or benefit leadership, but not through price. Explain?
Calculate the present value of the lease payments : A four-year fair market value lease with payments of $1,150 per month. Calculate the present value of the lease payments
What are the crime-control implications of social conflict : Name three different types of "Criminology" and explain what they consist of? What are the crime-control implications of social conflict theories?
Discuss case related to the employee benefit packages : A company is interested in offering its employees one of two employee benefit packages. A random sample of the company's employees is collected.
Prepare a sales budget and cash receipts budget : Prepare a sales budget, cash receipts budget, production budget, raw materials budget, and cash disbursements budget - peak sales coming in the third quarter
Environmental influences an organization faces : 1. Describe three (3) of the environmental influences an organization faces.
Examine the important elements of implementation : Provide your own definition of community-policing and explain the difference between community policing and traditional policing.
Identify a time in which you worked with a group : Identify a time in which you worked with a group (work group, church group, school group, etc.) where the experience was unpleasant.
What is the future value of his investment cash flows : If he can earn 7.5 percent on any investment that he makes, what is the future value of his investment cash flows at the end of three years

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Prepare the cost allocation desired by the hospital

Prepare the cost allocation desired by the hospital administrator. Include under each billing center the direct costs of the center as well as the costs allocated from the service departments.

  Funding budget shortfalls

Funding budget shortfalls As part of your personal budgeting process, you have determined that in each of the next 5 years you will have budget shortfalls.

  Bell company makes fax machines

Bell Company makes fax machines. Currently Bell makes all components of the fax machine in house. An outside company has offered to supply one component, part number B48 for $8 each. Bells uses 15,000 of these components per years. Costs of B48 are a..

  Total manufacturing overhead costs

How can I assign the total 2014 manufacturing overhead costs to the two products using activity based costing (ABC) and determine the overhead cost per unit.

  Calculate the amount of cash that skifurn expects

ACT 5140 – Accounting for Decision Makers - Calculate the amount of cash that Skifurn expects to collect in February and Calculate the budgeted

  Determine the break even point

Give the following cost data Costs /per unit labor . $ 4 Materials .5 Fixed cost . $ 12000 Determine the break even point in units if the selling price is $ 19.00 Determine the break-even point in sales at a selling price of $ 19.00 What would profit..

  Prepare the firms july production report

Direct material is added at the beginning of the production process, and conversion activity occurs uniformly throughout the process. Compute the missing amounts, and prepare the firm's July production report.

  Adria lopez, owner of success systems

Adria Lopez, owner of Success Systems, decides to prepare a statement of cash flows for her business.

  Define and provide one example of a cash inflow

Define and provide one example of a cash inflow and one example of a cash outflow for (a) Operating cash flows, (b) Investing cash flows, (c) Financing cash flows.

  What managerial insights are revealed by the computations

What managerial insights are revealed by the computations that you performed in this problem?

  Determine the equation for total operating costs

Calculate the break-even points between these three sizes - What is the minimum level of examinations the new optometrist must perform to pay for herself (break-even)?

  Prepare a revised operating budget for the fourth quarter

Prepare a revised operating budget for the fourth quarter for the Clark Services. This revised budget will be presented by Dick Smyth to General Service Industries.

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