Question

A. Direct Labor Budget Evans Company produces asphalt roofing materials. The production budget in bundles for...

A. Direct Labor Budget

Evans Company produces asphalt roofing materials. The production budget in bundles for Evans' most popular weight of asphalt shingle is shown for the following months:

Units
March 4,400
April 14,300
May 15,840
June 18,700

Each bundle produced requires (on average) 0.40 direct labor hours. The average cost of direct labor is $22 per hour.

Required:

Prepare a direct labor budget for March, April, and May, showing the hours needed and the direct labor cost for each month and in total. Do not include a multiplication symbol as part of your answer.

Evans Company
Direct Labor Budget
For March, April, and May
March April May Total
Units to be produced
Direct labor time per unit (hours)
Total hours needed
Cost per hour $ $ $ $
Total direct labor cost $ $ $ $

B.

Cash Budget

Aragon and Associates has found from past experience that 25% of its services are for cash. The remaining 75% are on credit. An aging schedule for accounts receivable reveals the following pattern:

  1. Ten percent of fees on credit are collected in the month that service is rendered.
  2. Sixty percent of fees on credit are collected in the month following service.
  3. Twenty-six percent of fees on credit are collected in the second month following service.
  4. Four percent of fees on credit are never collected.

Fees (on credit) that have not been paid until the second month following performance of the legal service are considered overdue and are subject to a 3% late charge.

Aragon has developed the following forecast of fees:

May $180,000
June 200,000
July 190,000
August 194,000
September 240,000

Required:

Prepare a schedule of cash receipts for August and September. If an amount box does not require an entry, leave it blank or enter "0". Round answers to the nearest dollar.

Aragon and Associates
Schedule of Cash Receipts
For August and September
August September
Cash fees $ $
Received from sales in:
June
July
August
September
Total $ $

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Watt’s Lighting Stores made the following sales projection for the next six months. All sales are...
Watt’s Lighting Stores made the following sales projection for the next six months. All sales are credit sales. March $43,000 June $47,000 April 49,000 July 55,000 May 38,000 August 57,000 Sales in January and February were $46,000 and $45,000, respectively. Experience has shown that of total sales, 10 percent are uncollectible, 35 percent are collected in the month of sale, 45 percent are collected in the following month, and 10 percent are collected two months after sale. a. Prepare a...
1. Shadee Corp. expects to sell 530 sun visors in May and 380 in June. Each...
1. Shadee Corp. expects to sell 530 sun visors in May and 380 in June. Each visor sells for $20. Shadee’s beginning and ending finished goods inventories for May are 85 and 45 units, respectively. Ending finished goods inventory for June will be 65 units. It expects the following unit sales for the third quarter: July 560 August 450 September 450 Sixty percent of Shadee’s sales are cash. Of the credit sales, 52 percent is collected in the month of...
AGENDA: PROFIT PLANNING (BUDGETING) Building a master budget. 1. Sales budget 2. Production budget 3. Direct...
AGENDA: PROFIT PLANNING (BUDGETING) Building a master budget. 1. Sales budget 2. Production budget 3. Direct materials budget 4. Direct labor budget 5. Manufacturing overhead budget 6. Ending finished goods inventory budget 7. Selling and administrative expenses budget 8. Cash budget 9. Budgeted income statement 10. Budgeted balance sheet OVERVIEW OF BUDGETING A budget is a detailed plan for acquiring and using financial and other resources over a specified period. Budgeting involves two stages: • Planning: Developing objectives and preparing...
RAMOS CO. Direct Materials Budget For April, May, and June April May June Budget production (units)...
RAMOS CO. Direct Materials Budget For April, May, and June April May June Budget production (units) 600 730 700 units Materials needed for production (lbs.) Total materials requirements (lbs.) Materials to be purchased (lbs.) Materials price per pound Budgeted cost of direct materials purchases Required information Ramos Co. provides the following sales forecast and production budget for the next four months. April May June July Sales (units) 660 740 690 760 Budgeted production (units) 600 730 700 700 The company...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its product on account. Roybal has the following accounts receivable payment experience: Percent paid in the month of sale 20 Percent paid in the month after the sale 55 Percent paid in the second month after the sale 23 To encourage payment in the month of sale, Roybal gives a 2% cash discount. Roybal's anticipated sales for the next few months are as follows: April...
Calculating the Cash Budget Here are some important figures from the budget of Cornell, Inc., for...
Calculating the Cash Budget Here are some important figures from the budget of Cornell, Inc., for the second quarter of 2017: April May June Credit sales $ 327,000 $ 307,000 $ 367,000 Credit purchases 135,000 158,000 183,000 Cash disbursements Wages, taxes, and expenses 44,700 12,200 63,700 Interest 11,700 11,700 11,700 Equipment purchases 87,000 164,000 0    The company predicts that 5 percent of its credit sales will never be collected, 25 percent of its sales will be collected in the...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $130,000 June 150,000 July 200,000 August 130,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: 60 percent in the month of sale. 20 percent in the month following sale. 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 2...
Fill in the missing amounts (there are six numbers that you need to find…labeled as (A)...
Fill in the missing amounts (there are six numbers that you need to find…labeled as (A) through (F)) in the following Cash receipt schedule. Enter ONLY the number (NO dollar sign). Round your answer to the nearest digit. Sales in the month of March = $192,000    Half of each month's sales are on account.  60%of credit sales is collected in the month of sale.    40%of credit sales is collected in the following month.                               April May June    Sales $256,000 $192,000 $289,200    Cash receipts:          From cash sales$(A)$(B) $144,600    From sales...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 35%...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 35% of its sales during the month were for cash. Bennett has the following accounts receivable payment experience: Percent paid in the month of sale 25 Percent paid in the month after the sale 68 Percent paid in the second month after the sale 5 Bennett's anticipated sales for the next few months are as follows: April $250,000 May 290,000 June 280,000 July 295,000 August...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 40%...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 40% of its sales during the month were for cash. Bennett has the following accounts receivable payment experience: Percent paid in the month of sale 25 Percent paid in the month after the sale 68 Percent paid in the second month after the sale 5 Bennett's anticipated sales for the next few months are as follows: April $250,000 May 290,000 June 280,000 July 295,000 August...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT