Budget
PT Joy is a company that produces paint. Sales projections and initial and final inventory data for 2020 are as follows:
Quarter
1 | 2 | 3 | 4 | Years | |
Unit | 19,000 | 17,500 | 19,680 | 20,700 | 76,880 |
Price | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 |
Beg. Inv | 1,000 | 1,340 | 600 | 1,120 | 1,000 |
End. Inv | 1,340 | 600 | 1,120 | 1,000 | 1,000 |
Each can of paint requires 4 liters of thinner at a price of IDR 300/liter, where the ending inventory is 25% of the production need and the beginning inventory is 2 times the ending inventory. Each can of paint takes 20 minutes to produce, with a labor wage of IDR 50/minute. The variable overhead rate is IDR 750/minute/ direct labor. Fixed overhead budgeted IDR20,000,000 per year.
Required:
Make a sales budget, production budget, direct material budget, direct labor budget, overhead budget for 2020 and give your explanation about the result!
Homework Answers
Request Answer!
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
Current Designs CD9 Diane Buswell is preparing the 2020 budget for one of Current Designs' rotomolded...
Current Designs CD9 Diane Buswell is preparing the 2020 budget for one of Current Designs' rotomolded Extensive meetings with members of the sales department and executive team have resulted in the lowing unit sales projections for 2020. Quarter 1 1,000 kayaks Quarter 2 1,500 kayaks Quarter 3 750 kayaks Quarter 4 750 kayaks Current Designs' policy is to have finished goods ending inventory in a quarter equal to 20% of the next quarter's anticipated sales. Preliminary sales projections for 2021...
Current Designs CD9 Diane Buswell is preparing the 2020 budget for one of Current Designs' rotomolded...
Current Designs CD9 Diane Buswell is preparing the 2020 budget for one of Current Designs' rotomolded Extensive meetings with members of the sales department and executive team have resulted in the lowing unit sales projections for 2020. Quarter 1 1,000 kayaks Quarter 2 1,500 kayaks Quarter 3 750 kayaks Quarter 4 750 kayaks Current Designs' policy is to have finished goods ending inventory in a quarter equal to 20% of the next quarter's anticipated sales. Preliminary sales projections for 2021...
ašes Current Designs Excel CD9 Diane Buswell is preparing the 2020 budget for one of Current...
ašes Current Designs Excel CD9 Diane Buswell is preparing the 2020 budget for one of Current Designs' rotomolded kayaks. Extensive meetings with members of the sales department and executive team have resulted in the fol- lowing unit sales projections for 2020 1,000 kayaks 1,500 kayaks 750 kayaks 750 kayaks Quarter Quarter 2 Quarter 3 Quarter 4 Current Designs' policy is to have finished goods ending inventory in a quarter equal to 20 % of the next quarter's anticipated sales. Preliminary...
Excel 2010 Help 1) create sales budget 2) operating budget 3) production budget 4) material req...
Excel 2010 Help 1) create sales budget 2) operating budget 3) production budget 4) material req budget 5) direct labor budget 6) manuf overhead budget 7) production per unit 8) projected income statement AB ales Projections In Units January February March April 20,609 26,521 27,815 49,644 47,350 Projected Sales Price/Unit $ 198.00 Monthly Projected Selling & Administrative Expenses Variable Cost/Unit Fixed Costs $5.00 $5,854 Production: 22.4% Desired Ending Inventory Beginning Inventory (new business) Materials 12.2% 14.0 Desired Ending Inventory Number...
Diane Buswell is preparing the 2020 budget for one of Current Designs’ rotomolded kayaks. Extensive meetings with members of the sales department and executive team have resulted in the following unit sales projections for 2020.
Quarter 1 Quarter 2 Quarter 3 Quarter 4 1,000 kayaks 1,500 kayaks 750 kayaks 750 kayaksCurrent Designs’ policy is to have finished goods ending inventory in a quarter equal to 20% of the next quarter’s anticipated sales. Preliminary sales projections for 2021 are 1,100 units for the first quarter and 1,500 units for the second quarter. Ending inventory of finished goods at December 31, 2019, will be 200 rotomolded kayaks.Production of each kayak requires 54 pounds of polyethylene powder and...
Use the following table to complete the budget sheet. Please help me solve this question, thank...
Use the following table to complete the budget sheet. Please
help me solve this question, thank you!!!
Balance Sheet March 31, 2018 Assets 52,000.00 9,000.00 2,750.00 14,300.00 Current Assets Cash Accounts Receivable Raw Materials Inventory (1,100 pounds) Finished Goods Inventory (2,000 units) Total Current Assets Plant and Equipment Equipment Accumulated Depreciation Plant and Equipment, Net Total Assets 78,050.00 930,000.00 (63,000.00) 867,000.00 945,050.00 7,500.00 100,000.00 Liabilities and Stockholders' Equity Liabilities Accounts Payable Bonds Payable Stockholders' Equity Common Stock 800,000.00 Retained Earnings...
The requirements are to correctly budget the following (this is all the directions and information given)....
The requirements are to correctly budget the following (this is
all the directions and information given). THIS IS ALL THE
INFORMATION I WAS GIVEN.
Perky Turkey Jerky, LLC Balance Sheet March 31, 2018 Assets 22,000.00 9,000.00 2,750.00 14,300.00 Current Assets Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory Total Current Assets Plant and Equipment Equipment Accumulated Depreciation Plant and Equipment, Net Total Assets 48,050.00 960,000.00 (63,000.00) 897,000.00 945,050.00 7,500.00 100,000.00 Liabilities and Stockholders' Equity Liabilities Accounts Payable Bonds Payable...
Can someone help with this. The Master Budget 1. Sales Budget 2. Production Budget Texas Rex...
Can someone help with this. The Master Budget 1. Sales Budget 2. Production Budget Texas Rex sells t-shirts. Expected sales for each quarter is 1000, 1200, 1500, and 2000 t-shirts at $10.00 each. They anticipate no price change. Texas Rex, Inc. Sales Budget For the year ending December 31, 2018 Q1 Q2 Q3 Q4 Total Units Unit Selling Price _______ _______ ________ _______ ________ Budgeted Sales A production budget tells management how many units must be produced to satisfy...
Please answer all 3 What appears in a capital expenditure budget? A. Expected units of sales...
Please answer all 3
What appears in a capital expenditure budget? A. Expected units of sales times the expected sales price B. Purchases of property, plant and equipment O C. Expected units of sales D. Production budget What is the starting point when developing the Direct Materials budget? O A. Production budget O B. Sales budget C. Manufacturing overhead budget O D. Direct labor budget For a Production budget and a Direct Materials budget, ifa beginning inventory number is not...
CHAPTER 8! MASTER DUDUL IN-CLASS PRACTICE PROBLEM - SALES BUDGET TO MANUFACTURING OVERHEAD BUDGET (SCHEDULES 1-10)...
CHAPTER 8! MASTER DUDUL IN-CLASS PRACTICE PROBLEM - SALES BUDGET TO MANUFACTURING OVERHEAD BUDGET (SCHEDULES 1-10) The following information pertains to the budgeting process for Tulip, Inc. SALES: Tulip, Inc. sell one type of decorative basket for $25 per basket. Based on various sales forecasting models, Tulip expects to sell 11.000 units in quarter 1. 10,000 in quarter 2, 12,000 in quarter 3 and 9,000 in quarter 4. The beginning accounts receivable balance was $58,000. Assuming all sales are made...
Current Designs CD9 Diane Buswell is preparing the 2020 budget for one of Current Designs' rotomolded Extensive meetings with members of the sales department and executive team have resulted in the lowing unit sales projections for 2020. Quarter 1 1,000 kayaks Quarter 2 1,500 kayaks Quarter 3 750 kayaks Quarter 4 750 kayaks Current Designs' policy is to have finished goods ending inventory in a quarter equal to 20% of the next quarter's anticipated sales. Preliminary sales projections for 2021...
Current Designs CD9 Diane Buswell is preparing the 2020 budget for one of Current Designs' rotomolded Extensive meetings with members of the sales department and executive team have resulted in the lowing unit sales projections for 2020. Quarter 1 1,000 kayaks Quarter 2 1,500 kayaks Quarter 3 750 kayaks Quarter 4 750 kayaks Current Designs' policy is to have finished goods ending inventory in a quarter equal to 20% of the next quarter's anticipated sales. Preliminary sales projections for 2021...
ašes Current Designs Excel CD9 Diane Buswell is preparing the 2020 budget for one of Current Designs' rotomolded kayaks. Extensive meetings with members of the sales department and executive team have resulted in the fol- lowing unit sales projections for 2020 1,000 kayaks 1,500 kayaks 750 kayaks 750 kayaks Quarter Quarter 2 Quarter 3 Quarter 4 Current Designs' policy is to have finished goods ending inventory in a quarter equal to 20 % of the next quarter's anticipated sales. Preliminary...
Excel 2010 Help 1) create sales budget 2) operating budget 3) production budget 4) material req budget 5) direct labor budget 6) manuf overhead budget 7) production per unit 8) projected income statement AB ales Projections In Units January February March April 20,609 26,521 27,815 49,644 47,350 Projected Sales Price/Unit $ 198.00 Monthly Projected Selling & Administrative Expenses Variable Cost/Unit Fixed Costs $5.00 $5,854 Production: 22.4% Desired Ending Inventory Beginning Inventory (new business) Materials 12.2% 14.0 Desired Ending Inventory Number...
Use the following table to complete the budget sheet. Please
help me solve this question, thank you!!!
Balance Sheet March 31, 2018 Assets 52,000.00 9,000.00 2,750.00 14,300.00 Current Assets Cash Accounts Receivable Raw Materials Inventory (1,100 pounds) Finished Goods Inventory (2,000 units) Total Current Assets Plant and Equipment Equipment Accumulated Depreciation Plant and Equipment, Net Total Assets 78,050.00 930,000.00 (63,000.00) 867,000.00 945,050.00 7,500.00 100,000.00 Liabilities and Stockholders' Equity Liabilities Accounts Payable Bonds Payable Stockholders' Equity Common Stock 800,000.00 Retained Earnings...
The requirements are to correctly budget the following (this is
all the directions and information given). THIS IS ALL THE
INFORMATION I WAS GIVEN.
Perky Turkey Jerky, LLC Balance Sheet March 31, 2018 Assets 22,000.00 9,000.00 2,750.00 14,300.00 Current Assets Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory Total Current Assets Plant and Equipment Equipment Accumulated Depreciation Plant and Equipment, Net Total Assets 48,050.00 960,000.00 (63,000.00) 897,000.00 945,050.00 7,500.00 100,000.00 Liabilities and Stockholders' Equity Liabilities Accounts Payable Bonds Payable...
Please answer all 3
What appears in a capital expenditure budget? A. Expected units of sales times the expected sales price B. Purchases of property, plant and equipment O C. Expected units of sales D. Production budget What is the starting point when developing the Direct Materials budget? O A. Production budget O B. Sales budget C. Manufacturing overhead budget O D. Direct labor budget For a Production budget and a Direct Materials budget, ifa beginning inventory number is not...
CHAPTER 8! MASTER DUDUL IN-CLASS PRACTICE PROBLEM - SALES BUDGET TO MANUFACTURING OVERHEAD BUDGET (SCHEDULES 1-10) The following information pertains to the budgeting process for Tulip, Inc. SALES: Tulip, Inc. sell one type of decorative basket for $25 per basket. Based on various sales forecasting models, Tulip expects to sell 11.000 units in quarter 1. 10,000 in quarter 2, 12,000 in quarter 3 and 9,000 in quarter 4. The beginning accounts receivable balance was $58,000. Assuming all sales are made...
Most questions answered within 3 hours.
-
Your task is to write a paper from one to two pages (double
spaced) that analyzes...
asked 30 minutes ago -
A gene has four alleles, A1, A2,
A3, and A4. The alleles occur in a population...
asked 2 hours ago -
Solve the problem. Please show steps a) Common Equity(C/E) is
$400,000(No Debt), Sales are $600,000, NI...
asked 1 hour ago -
A patient is given 0.055 mg of technetium-99 m, a radioactive
isotope with a half-life of...
asked 2 hours ago -
Discuss when you think a broad banding pay structure might work
best and why. If you...
asked 2 hours ago -
A child's mother has type A blood. Their father has type B
blood. The child has...
asked 4 hours ago -
Last year's dividend (D0) was$3.20per share. The constant growth
in dividends=6.25%. Required return=12%.
Requirement 1:
What...
asked 3 hours ago -
What is the chemical equation for the reaction that occurs
between hydrochloric acid & potassium carbonate?...
asked 3 hours ago -
Today is your 25th birthday, and you want to save $1.9 Million
by your birthday at...
asked 4 hours ago -
James Bakery sells cupcakes to William's Restaurant. The credit
terms are 1%/5/net 15. The selling price...
asked 6 hours ago -
The cost of ink cartridges for inkjet printers can be
substantial over the life of a...
asked 6 hours ago -
what do you think would be your reservations in
relaying on the linear regression model for...
asked 6 hours ago