The production department of Priston Company has submitted thefollowing forecast of units to be produced by quarter for theupcoming fiscal year.
1stQuarter 2ndQuarter 3rdQuarter 4thQuarter Units to be produced 10,000 11,000 12,000 9,000
In addition, the beginning raw materials inventory for the 1stQuarter is budgeted to be 5,000 pounds and the beginning accountspayable for the 1st Quarter is budgeted to be $19,000.
Each unit requires two pounds ofraw material that costs $4.00 per pound. Management desires to endeach quarter with a raw materials inventory equal to 25% of thefollowing quarterâs production needs. The desired ending inventoryfor the 4th Quarter is 6,750 pounds. Management plans to pay for60% of raw material purchases in the quarter acquired and 40% inthe following quarter. Each unit requires 0.75 direct labor-hoursand direct labor-hour workers are paid $13 per hour.
Required: 1a. Prepare the companyâs direct materials budget for the upcomingfiscal year. (Input all amounts as positive values. Do notround intermediate calculations.)
Priston Company
Direct Materials Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Production needs - pounds (Click to select)DeductAdd: (Click to select)BeginninginventoryEnding inventory Total needs - pounds (Click to select)AddDeduct: (Click to select)EndinginventoryBeginning inventory Rawmaterials to be purchased - pounds Costof raw materials to be purchased $ $ $ $ $
1b. Prepare a schedule of expected cash disbursements for purchasesof materials for the upcoming fiscal year. (Leave no cellsblank - be certain to enter "0" wherever required. Do not roundintermediate calculations.)
Priston Company
Schedule of Expected Cash Disbursements for Materials 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Accounts payable, beginning balance $ $ $ $ $ 1stQuarter purchases 2ndQuarter purchases 3rdQuarter purchases 4thQuarter purchases Total cash disbursements for materials $ $ $ $ $
2. Complete the company's direct labor budget for the upcomingfiscal year, assuming that the direct labor workforce is adjustedeach quarter to match the number of hours required to produce theforecasted number of units produced.
Priston Company
Direct Labor Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Total direct labor-hours needed Total direct labor cost $ $ $ $ $
The production department of Priston Company has submitted thefollowing forecast of units to be produced by quarter for theupcoming fiscal year.
1stQuarter | 2ndQuarter | 3rdQuarter | 4thQuarter | |
Units to be produced | 10,000 | 11,000 | 12,000 | 9,000 |
In addition, the beginning raw materials inventory for the 1stQuarter is budgeted to be 5,000 pounds and the beginning accountspayable for the 1st Quarter is budgeted to be $19,000. |
Each unit requires two pounds ofraw material that costs $4.00 per pound. Management desires to endeach quarter with a raw materials inventory equal to 25% of thefollowing quarterâs production needs. The desired ending inventoryfor the 4th Quarter is 6,750 pounds. Management plans to pay for60% of raw material purchases in the quarter acquired and 40% inthe following quarter. Each unit requires 0.75 direct labor-hoursand direct labor-hour workers are paid $13 per hour. |
Required: | |
1a. | Prepare the companyâs direct materials budget for the upcomingfiscal year. (Input all amounts as positive values. Do notround intermediate calculations.) |
Priston Company Direct Materials Budget | |||||
1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Year | |
Production needs - pounds | |||||
(Click to select)DeductAdd: (Click to select)BeginninginventoryEnding inventory | |||||
Total needs - pounds | |||||
(Click to select)AddDeduct: (Click to select)EndinginventoryBeginning inventory | |||||
Rawmaterials to be purchased - pounds | |||||
Costof raw materials to be purchased | $ | $ | $ | $ | $ |
1b. | Prepare a schedule of expected cash disbursements for purchasesof materials for the upcoming fiscal year. (Leave no cellsblank - be certain to enter "0" wherever required. Do not roundintermediate calculations.) |
Priston Company Schedule of Expected Cash Disbursements for Materials | |||||
1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Year | |
Accounts payable, beginning balance | $ | $ | $ | $ | $ |
1stQuarter purchases | |||||
2ndQuarter purchases | |||||
3rdQuarter purchases | |||||
4thQuarter purchases | |||||
Total cash disbursements for materials | $ | $ | $ | $ | $ |
2. | Complete the company's direct labor budget for the upcomingfiscal year, assuming that the direct labor workforce is adjustedeach quarter to match the number of hours required to produce theforecasted number of units produced. |
Priston Company Direct Labor Budget | |||||
1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Year | |
Total direct labor-hours needed | |||||
Total direct labor cost | $ | $ | $ | $ | $ |