Homework Answers
1
| Sales Budget | ||||
| Particulars | Unit Price($) | Units | Total | |
| Sales | 15 | 100000 | 1500000 | 15*100000 |
2
| Production Budget | |
| Sales units | 100000 |
| Add Closing Inventory | 12000 |
| Less Opening Inventory | -8000 |
| Production Units | 104000 |
3
| Direct Material Purchase Budget | ||
| Producton kg(units *4) | 416000 | 104000*4 |
| add desired closing inventory | 6000 | |
| less opening inventory | -4000 | |
| Purchase quantity(kg) | 418000 | |
| cost per kg($) | 2.5 | |
| Budgeted Purchase | 1045000 | 418000*2.5 |
4.
| Direct Labor Budget | ||
| number of racks produced | 104000 | |
| time per rack | 30 min | |
| total time (104000*30) | 3120000 min | |
| or | 52000 hrs | 3120000/60 |
| Labor Cost per hour | 9$ | |
| Total Labor cost Budget | 468000$ | 52000*9 |
Add Answer to:
QUESTION 1 POR FINANCIAL MANAGEMENTOcx Word Product Activation Failed ERENCES MALING BEVIEW VIEW QUESTION 1 (15)...
You have recently been hired by Forty Company as a managerial accountant. It has not used...
You have recently been hired by Forty Company as a managerial accountant. It has not used budgets in the past but is expecting large growth in the next year and needs to get a loan to pay for the expansion. In order to determine the loan amount, your manager asks you to prepare the following budgets: sales budget, production budget, direct materials purchases budget, direct labor budget, and overhead budget. Directions Prepare each budget of this assignment in one Excel...
E10.18 Prepare quarterly sales budgets. Roche and Young, CPAS, are preparing their service revenue (sales) budget...
E10.18 Prepare quarterly sales budgets. Roche and Young, CPAS, are preparing their service revenue (sales) budget for 2020. Their practice is divided into three departments: auditing, tax, and consulting. Billable hours for each department, by quarter, are as follows: Department Quarter 1 Quarter 2 Quarter 3 Quarter 4 Auditing 2,200 1,600 2,000 2,400 3,000 2,500 Тах 2,400 2,000 Consulting 1,500 1,500 1,500 1,500 Average hourly billing rates are $60 for auditing, $70 for tax, and $80 for consulting services. Instructions...
SarasotaCompany is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and...
SarasotaCompany is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales. Sales for the year are expected to total 1,200,000 units. Quarterly sales are 18%, 25%, 23%, and 34%, respectively. The sales price is expected to be $38 per unit for the first three quarters and $47 per unit beginning in the fourth quarter. Sales in the first quarter of 2018 are expected to be 10% higher than...
Production Budget and Direct Materials Purchases Budgets Peanut Land Inc. produces all-natural organic peanut butter. The...
Production Budget and Direct Materials Purchases Budgets Peanut Land Inc. produces all-natural organic peanut butter. The peanut butter is sold in 12-ounce jars. The sales budget for the first four months of the year is as follows: Unit Sales Dollar Sales ($) January 40,000 72,000 February 45,000 81,000 March 60,000 108,000 April 42,000 75,600 Company policy requires that ending inventories for each month be 20% of next month's sales. At the beginning of January, the inventory of peanut butter is...
Answer in excel Problems: 1. Benliver, Inc. manufactures and distributes a number or products to retailers....
Answer in excel
Problems: 1. Benliver, Inc. manufactures and distributes a number or products to retailers. One of these products. Super Jetdry, requires two pounds of material R2D8 in the manufacture of each unit. The company is now planning raw materials needs for the third quarter - July August, and September. Peak sales of Super Jetdry occur in the third quarter of each year. To keep production and shipments moving smoothly, the company has the following inventory requirements: a. The...
Hiking Co ("the company") needs your help with preparing their operating budgets for the coming year....
Hiking Co ("the company") needs your help with preparing their operating budgets for the coming year. They have asked you to focus on their walking shorts product line for the first quarter of 2020. The projected sales for the first quarter of 2020 and the projected beginning and ending inventory balances are as follows: Unit sales are 10,000 for the quarter. Unit sales price is $25 per unit. Number of units in closing inventory on Dec 31, 2019 is 0...
Palmgren Company produces consumer products. The sales budget for four months of the year is presented...
Palmgren Company produces consumer products. The sales budget for four months of the year is presented below. July August September October Unit Sales 32,500 33,700 38,000 36,000 Dollar Sales $975,000 1,061,550 1,197,000 1,141,200 Company policy requires that ending inventories for each month be 25 percent of next month's sales. At the beginning of July, the beginning inventory of consumer products met that policy. Required: Prepare a production budget for the third quarter of the year. Show the number of units...
Question 3 Cook Farm Supply Company manufactures and sells a pesticide called Snare. The following data...
Question 3 Cook Farm Supply Company manufactures and sells a pesticide called Snare. The following data are available for preparing budgets for Snare for the first 2 quarters of 2020. 1. Sales: quarter 1, 28,000 bags; quarter 2, 43,000 bags. Selling price is $61 per bag. 2. Direct materials: each bag of Snare requires 5 pounds of Gumm at a cost of $3.80 per pound and 6 pounds of Tarr at $1.75 per pound. 3. Desired inventory levels: Type of...
I provided photos that have information need to answer the question. I only need help with the pi...
I provided photos that have information need to answer the
question. I only need help with the picture of Chart D (for the
first quater of 2017, prepare a direct labor budget.) its the
picture of the blank chart. Thank you!
Waterways Corporation is preparing its budget for the coming year, 2017. The first step is to plan for the first quarter of that coming year. Waterways gathered the following information from the managers. Sales Unit sales for November 2016...
Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft...
Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: January 40,000 February 50,000 March 60,000 April 60,000 May 62,000 The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: Finished goods inventory on January 1 is 32,000 units, each costing $166.06. The desired ending inventory for each...
E10.18 Prepare quarterly sales budgets. Roche and Young, CPAS, are preparing their service revenue (sales) budget for 2020. Their practice is divided into three departments: auditing, tax, and consulting. Billable hours for each department, by quarter, are as follows: Department Quarter 1 Quarter 2 Quarter 3 Quarter 4 Auditing 2,200 1,600 2,000 2,400 3,000 2,500 Тах 2,400 2,000 Consulting 1,500 1,500 1,500 1,500 Average hourly billing rates are $60 for auditing, $70 for tax, and $80 for consulting services. Instructions...
SarasotaCompany is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales. Sales for the year are expected to total 1,200,000 units. Quarterly sales are 18%, 25%, 23%, and 34%, respectively. The sales price is expected to be $38 per unit for the first three quarters and $47 per unit beginning in the fourth quarter. Sales in the first quarter of 2018 are expected to be 10% higher than...
Answer in excel
Problems: 1. Benliver, Inc. manufactures and distributes a number or products to retailers. One of these products. Super Jetdry, requires two pounds of material R2D8 in the manufacture of each unit. The company is now planning raw materials needs for the third quarter - July August, and September. Peak sales of Super Jetdry occur in the third quarter of each year. To keep production and shipments moving smoothly, the company has the following inventory requirements: a. The...
Hiking Co ("the company") needs your help with preparing their operating budgets for the coming year. They have asked you to focus on their walking shorts product line for the first quarter of 2020. The projected sales for the first quarter of 2020 and the projected beginning and ending inventory balances are as follows: Unit sales are 10,000 for the quarter. Unit sales price is $25 per unit. Number of units in closing inventory on Dec 31, 2019 is 0...
Palmgren Company produces consumer products. The sales budget for four months of the year is presented below. July August September October Unit Sales 32,500 33,700 38,000 36,000 Dollar Sales $975,000 1,061,550 1,197,000 1,141,200 Company policy requires that ending inventories for each month be 25 percent of next month's sales. At the beginning of July, the beginning inventory of consumer products met that policy. Required: Prepare a production budget for the third quarter of the year. Show the number of units...
Question 3 Cook Farm Supply Company manufactures and sells a pesticide called Snare. The following data are available for preparing budgets for Snare for the first 2 quarters of 2020. 1. Sales: quarter 1, 28,000 bags; quarter 2, 43,000 bags. Selling price is $61 per bag. 2. Direct materials: each bag of Snare requires 5 pounds of Gumm at a cost of $3.80 per pound and 6 pounds of Tarr at $1.75 per pound. 3. Desired inventory levels: Type of...
I provided photos that have information need to answer the
question. I only need help with the picture of Chart D (for the
first quater of 2017, prepare a direct labor budget.) its the
picture of the blank chart. Thank you!
Waterways Corporation is preparing its budget for the coming year, 2017. The first step is to plan for the first quarter of that coming year. Waterways gathered the following information from the managers. Sales Unit sales for November 2016...
Most questions answered within 3 hours.
-
. For this set of questions, determine what
proportion of a normal distribution is located betweeneach...
asked 21 minutes ago -
A college student is employed as a door-to-door newspaper
salesman. Historical data suggests that the student...
asked 1 hour ago -
MATLAB HW 11 problem using Switch Case and Input commands
Write a script file that calculates...
asked 1 hour ago -
Considering gravitational time dilation, calculate the time that
passes in Earth’s surface while 1 hour passes...
asked 1 hour ago -
Minitab Problem: Take the Lake Hume June rainfall data and find
use the processes outlined in...
asked 2 hours ago -
X Company is trying to decide whether to continue using old
equipment to make Product A...
asked 2 hours ago -
IN PYTHON ONLY !! Program 2: Re-work
program #5 (WeeklyHours) from the previous assignment such that...
asked 3 hours ago -
The average length of time between arrivals at a turnpike
toll-booth is 26 seconds. What is...
asked 4 hours ago -
(a) A piston at 6.1 atm contains a gas that occupies a volume of
3.5 L....
asked 6 hours ago -
Please answer true or false. Words
cannot be changed or added in to make it true...
asked 6 hours ago -
An empty test tube weighs 15.923 grams. Then,
MgCl2•6H2O is added into the test tube. After...
asked 6 hours ago -
Assume memory access is 10 units of time and disk access is
10000 units of time....
asked 6 hours ago