Budgeted Sales Assignment

ABC Company manufactures and sells a single product. The following information is available concerning the operations for 1999.

a. The company's single product sells for $60 per unit. Budgeted sales in units for the next four quarters are:

1999   Quarter 1       3,000 Budgeted sales in units

1999   Quarter 2       3,500 Budgeted sales in units

1999   Quarter 3       4,000 Budgeted sales in units

1999   Quarter 4       4,500 Budgeted sales in units

2000   Quarter 1       5,000 Budgeted sales in units

b. Sales are collected in the following pattern: 80% in the quarter in which the sale is made, 19% in the following quarter. On January 1, 1999, the company's balance sheet showed $60,000 in account receivables, all of which will be collected in the first quarter of the year 1999. Bad debts are projected at 1% of quarterly sales. There is a -0- balance in the AFDA account.

c. The company requires an ending inventory of finished units on hand at the end of each quarter equal to 20% of the budgeted sales for the next quarter. This requirement was met on December 31, 19×8.  (The company had 600 units on hand to start the new-year).

d. Two pounds (2lbs) 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. This requirement was met on December 31, 19×8.  (The company had 620 lbs of raw materials on hand to start the new-year). Quarter 1 of the next year (year 2000) is estimated at 10,200 lbs needed for production.

e. The raw material costs $4.00 per pound. Purchases of raw material are paid for in the following pattern: 50% paid in the quarter in which the purchase was made, and the remaining 50% is paid in the following quarter. On January 1, 1999, the company's balance sheet showed $10,600 in accounts payable for raw material purchases.  All of which will be paid for in the first quarter of the year 1999.

f. Manufacturing overhead and selling & administrative expenses are paid in the quarter incurred.  The only exception is depreciation.

g. The manufacturing overhead budget distinguishes between variable and fixed overhead costs. Variable costs fluctuate with production volume on the basis of the following rates per direct labor hour: indirect materials $1.00, indirect labor $1.40, utilities $0.40, and maintenance $0.20. Fixed costs per quarter are: Supervisory Salaries $20,000, Depreciation $3,800, Property Taxes & Insurance $9,000 and Maintenance $5,700. Overhead is applied to production on the basis of direct labor hours. The annual rate is $8 per hour. (Hint: Total Manufacturing Overhead for 1999 $246,400 / Direct Labor hours 30,800 hours = $8/direct labor hour).

h. Selling & administrative expense budget distinguishes between variable and fixed overhead costs.  Variable costs are Sales Commissions of $3.00 and Freight-Out $1.00. Variable expenses per quarter are based on the unit sales projected in the sales budget. Fixed costs, per quarter, are:  Advertising $5,000, Sales Salaries $15,000, Office Salaries $7,500 Depreciation $1,000 and Property Taxes & Insurance $1,500.

i. January 1, 1999, cash balance is expected to be $38,000.

j. Marketable securities are expected to be sold for $2,000 cash in the first quarter.

k. 2 hours of direct labor are required to produce each unit of finished goods and the anticipated hourly wage rate is $10. Direct Labor is paid 100% in the quarter incurred.

l. Management plans to purchase new factory equipment in the second quarter for $50,000.

m. Management plans to purchase new office computers in the third quarter for $12,000.

n. Assume depreciation on new purchases is accounted for quarterly budgeted depreciation amounts.

o. Management plans to sell old equipment at the end of the fourth quarter for $3,000. Purchase price is $20,000, on January 1, 1996. Depreciation is calculated using the straight-line method, useful life estimated at five years, with no residual value.

p. The company makes equal quarterly payments of its estimated annual income taxes in the amount of $3,000 per quarter.

q. Loans are repaid in the first subsequent quarter in which there is sufficient cash (incurring 8% interest if funds are borrowed.)

r. A minimum cash balance of $20,000 is maintained per quarter.

s. Budgeted balance sheet information as of December 31, 1998 were: Building & Equipment $ 182,000, Common Stock $ 225,000, Accumulated Depreciation$ 28,800 and Retained Earnings of $ 46,480.


You must follow the posted lecture on Budgets that I authored.

UsingExceland the information above, prepare the following budgets and schedules for the year 1999, showing both quarterly and the year total figures:
1. Sales budget & schedule of cash collections from customers
2. Production budget
3. Direct materials budget & schedule of expected payments for direct materials
4. Direct labor budget
5. Manufacturing overhead budget
6. Selling & administrative expense budget
7. Cash budget
In addition, complete the following:

A. Finished goods inventory budget (Schedule)
B. Budgeted income statement (Budgeted financial statement)
C. Budgeted balance sheet (Budgeted financial statement) .

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Australia Assessments
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Good work
Customer 463647, December 15th, 2022
Good work!
Customer 463337, March 10th, 2023
Commitment Statement for Canberra - Subclass 491 Offshore Visa
Thank you so much for all your help and support. Thank you writer for all your efforts and great work. Thank you all once again.
Customer 455757, January 29th, 2022
good job
Customer 456821, January 5th, 2022
Customer 456821, October 4th, 2022
This week's order was phenomenally written and I did not have to request any revisions! Thank you to the writer for following all instructions as written and writing a phenomenal discussion paper.
Customer 452455, February 3rd, 2023
The writer did a phenomenal job with the Research Report #1: Data Breach Incident Analysis & Report. All expectations were met and exceeded! Thank you for delivering an amazing product and a HUGE thank you to the customer service department for sending me an email to let me know the paper was checked to quality assurance team to ensure the paper was within standards of the instructions.
Customer 452455, February 3rd, 2023
Business and administrative studies
Excellent work!
Customer 452719, June 11th, 2022
Good work. Thank you for following the instructions and the corrections, and making the necessary changes.
Customer 463679, March 3rd, 2023
Social Work and Human Services
All of the papers I have so far received have me extremely satisfied. The content that is asked for each task is written by the writers in great detail, and they perform a fantastic job of it. I'll keep using the service and tell other people about it. Again, many thanks.
Customer 463411, January 29th, 2023
Thank you for your work. Some sentences required minimal edits for clarification/explanation. In the future, please review your sentences for clarity and readability. Consider also reading out loud before submitting. We look forward to future contributions.
Customer 463469, October 21st, 2022
Marketing & Advertising
Well researched paper. Fresh and Informative
Customer 463369, September 22nd, 2022
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat