Computer Assignment
The SK Industries, Inc. manufactures and sells two products, Accel Active and Accel Regular. In September 2018, SK Industries Budget Department gathered the following data in order to prepare budgets for 2019:
2019 Projected Sales
Product |
Units |
Price |
Accel Active |
45,000 |
$225 |
Accel Regular |
75,000 |
$155 |
Expected Target Inventories
Product |
January 1, 2019 |
December 31, 2019 |
Accel Active |
9,000 |
12,000 |
Accel Regular |
17,000 |
25,000 |
The following direct materials are expected to be used in the two products:
Material Used per Unit |
|||
Direct Material |
Unit |
Accel Active |
Accel Regular |
One |
pound |
6 |
4 |
Two |
pound |
4 |
2 |
Three |
pound |
2 |
0 |
Projected data for 2019 with respect to direct materials are as follows:
Direct Material |
Expected Purchase Price |
Expected Inventories |
Target Inventories |
One |
$15 |
27,000 lb |
35,000 lb |
Two |
$7 |
30,000 lb |
35,000 lb |
Three |
$ 4 |
4,000 lb |
7,000 lb |
Projected direct labor requirements and rates for 2019 are as follows:
Product |
Hours Per Unit |
Rate Per Hour |
Accel Active |
4 |
$18 |
Accel Regular |
3 |
$15 |
Manufacturing overhead is allocated at the rate of $22 per direct manufacturing labor-hour. Required: Based on the preceding projections and budget requirements for Accel Active and Accel Regular, prepare the following budgets for 2019:
ANSWER
Revenues budget (in dollars) | ||||
Accel Active | Accel Regular | Total | ||
Units Sold | 45,000 | 75,000 | ||
Multiply: Selling Price per unit | $225 | $155 | ||
Sales Revenue | $10,125,000 | $11,625,000 | $21,750,000 | |
Production budget (in units) | ||||
Accel Active | Accel Regular | |||
Units sold | 45,000 | 75,000 | ||
Add: ending finished goods inventory | 12,000 | 25,000 | ||
Units available for sale | 57,000 | 100,000 | ||
Less: Beginning finished goods inventory | 9,000 | 17,000 | ||
Units Produced | 48,000 | 83,000 | ||
Direct materials purchases budget (in quantities) | ||||
Material one | Material two | Material Three | ||
Units Produced for Accel Active | 48,000 | 48,000 | 48,000 | |
Multiply: Material Used per Unit for Production of Accel Active | 6 | 4 | 2 | |
Material required for Production of Accel Active | 288,000 | 192,000 | 96,000 | |
Units Produced for Accel Regular | 83,000 | 83,000 | 83,000 | |
Multiply: Material Used per Unit for Production of Accel Regular | 4 | 2 | - | |
Material required for Production of Accel Regular | 332,000 | 166,000 | - | |
Material required for Production of Accel Active | 288,000 | 192,000 | 96,000 | |
Material required for Production of Accel Regular | 332,000 | 166,000 | - | |
Material required for Production of finished goods | 620,000 | 358,000 | 96,000 | |
Material required for Production of finished goods | 620,000 | 358,000 | 96,000 | |
Add: ending raw material | 35,000 | 35,000 | 7,000 | |
Raw material Available for use | 655,000 | 393,000 | 103,000 | |
Less: Beginning raw material | 27,000 | 30,000 | 4,000 | |
Purchase of material (in pounds) | 628,000 | 363,000 | 99,000 | |
Direct materials purchases budget (in dollars) | ||||
Material one | Material two | Material Three | Total | |
Purchase of material (in pounds) | 628,000 | 363,000 | 99,000 | |
Multiply by: cost per Pound | $15 | $7 | $4 | |
Cost of material purchased | $9,420,000 | $2,541,000 | $396,000 | $12,357,000 |
Direct manufacturing labor budget (in dollars) | ||||
Accel Active | Accel Regular | Total | ||
Units Produced | 48,000 | 83,000 | ||
Multiply: Hour per unit | 4 | 3 | ||
Total Hour needed | 192,000 | 249,000 | ||
Multiply: labour rate per hour | $18 | $15 | ||
Direct labor cost | $3,456,000 | $3,735,000 | $7,191,000 | |
Direct manufacturing overhead budget (in dollars) | ||||
Accel Active | Accel Regular | Total | ||
Total Hour needed | 192,000 | 249,000 | ||
Multiply: Manufacturing overhead per labour hour | $22 | $22 | ||
Direct manufacturing overhead | $4,224,000 | $5,478,000 | $9,702,000 | |
Budgeted finished goods inventory at December 31, 2019 (in dollars) | ||||
Accel Active | Accel Regular | Total | ||
Material cost per unit | ||||
Accel Active (($15*6)+($7*4)+($4*2)) | $126 | |||
Accel Regular(($15*4)+($7*2)+($4*0)) | $74 | |||
Labor cost per unit | ||||
Accel Active($18*4) | $72 | |||
Accel Regular($15*3) | $ 45 | |||
Manufacturing overhead per unit | ||||
Accel Active ($22*4) | $88 | |||
Accel Regular($22*3) | $66 | |||
Manufacturing cost per unit | $286 | $185 | ||
Ending Finished goods inventory, December 31, 2019 | 12,000 | 25,000 | ||
Multiply: Manufacturing cost per unit | $ 286 | $ 185 | ||
Budgeted finished goods inventory at December 31, 2019 (in dollars) | $3,432,000 | $4,625,000 | $8,057,000 | |
Cost of Goods Sold budget (in dollars) | ||||
Accel Active | Accel Regular | Total | ||
Units Sold | 45,000 | 75,000 | ||
Multiply: Manufacturing cost per unit | $286 | $185 | ||
Cost of Goods Sold budget (in dollars) | $12,870,000 | $13,875,000 | $26,745,000 |
================
DEAR STUDENT,
IF YOU HAVE ANY QUERY PLEASE ASK ME IN THE COMMENT BOX,I AM HERE TO HELP YOU.PLEASE GIVE ME POSITIVE RATING..
****************THANK YOU****************
Computer Assignment The SK Industries, Inc. manufactures and sells two products, Accel Active and Accel Regular....
1. Scarborough Corporation manufactures and sells two products: D-One and D-Two. In July 2018, Scarborough budget department gathered the following data to prepare budgets for 2019 2019 Projected Sales: Units Product Price D-One 60,000 40,000 S165 D-Two S250 2019 Inventories in Units: Expected Target Product January 1, 2019 20,000 December 31, 2019 25,000 D-One D-Two 8,000 9,000 The following direct materials are used in the two products Amount Used per Unit Direct material Unit D-One D-Two kilogram kilogram each Projected...
I am stuck on question 7 and 8 - Budget Finished goods inventory and cost of goods sold The SmartProduct Corporation manufactures and sells three products: ExcelWidget, GoodWidget, and FairWidget. In June 2020, SmartProduct’s Budget Department gathered the following data in order to prepare budgets for 2021: 2021 Projected Sales Product Units Price ExcelWidget 32,000 $270 GoodWidget 28,000 $190 FairWidget 65,000 $145 Expected Target Inventories Product January 1, 2021 December 31, 2021 ExcelWidget 24,000 27,000 GoodWidget 15,000 20,000 FairWidget 17,000...
Requirement 4. Prepare the direct material purchases budget (in quantities). (For entries with a balance, make sure to enter "0" in the appropriate field.) Direct Materials Purchases Budget (in Quantities) For the Year Ending December 31, 2017 Direct Materials A B с To be used in production Thingone Thingtwo Total Add target ending Inventory Total requirements Deduct beginning inventory Purchases to be made (units) Enter any number in the edit fields and then click Check Answer. or data.) manufacturing labor-hour....
Problem 4) Operating budget for a manufacturing company Comfort Furniture Corp. manufacturers and sells two types of tables: Regular and Deluxe. In July 2017, the company’s budget department gathered the following data to prepare 2018 budget. Direct Materials used to produce one table Direct Material Unit Regular Deluxe A pound 4 lbs 5 lbs B pound 2 lbs 3 lbs C each 0 1 unit Projected Sales in 2018: Regular 60,000 tables at $165/table Deluxe 40,000 tables at $250/table Target...
Q.6. Britton Corporation manufactures and sells two products, Thingone and Thingtwo. In July, 20A, the company's Budget Department gathered the following data to project sales and budget requirement for 20B: Projected sales: Product Units Price Thingone 60,000 $ 70 Thingtwo 40,000 100 Inventories (in Units): Product Expected January 1, 20B Desired December 31,20B Thingone 20,000 25,000 Thingtwo 8,000 9,000 To produce one unit of Thingone and Thingtwo, the following raw materials are used Amount used per unit Raw Material Thingone...
Required information [The following information applies to the questions displayed below.) Vista Electronics, Inc. manufactures two different types of coils used in electric motors. In the fall of the current year, Erica Becker, the controller, compiled the following data. • Sales forecast for 20x0 (all units to be shipped in 20x0): Product Light coil Heavy coil Units 54,000 34,000 Price $ 240 340 • Raw-material prices and inventory levels: Raw Material Sheet metal Copper wire Platform Expected Inventories, January 1,...
Required information [The following information applies to the questions displayed below.j Vista Electronics, Inc. manufactures two different types of coils used in electric motors. In the fall of the current year, Erica Becker, the controller, compiled the following data Sales forecast for 20x0 (all units to be shipped in 20xO) Product Light coil 51,000 210 Heavy coil 31,000 Units Price 310 Raw-material prices and inventory levels Expected Inventories, Desired Inventories, December 31, 20x0 33,000 lb 29,000 lb. Anticipated Purchase Price...
Vista Electronics, Inc. manufactures two different types of coils used in electric motors. In the fall of the current year, Erica Becker, the controller, compiled the following data. Sales forecast for 20x0 (all units to be shipped in 20x0): Product Units Price Light coil 51,000 $ 210 Heavy coil 31,000 310 Raw-material prices and inventory levels: Raw Material Expected Inventories, January 1, 20x0 Desired Inventories, December 31, 20x0 Anticipated Purchase Price Sheet metal 29,000 lb. 33,000 lb. $ 18 Copper...
Autorent 2 ACCM Wond EndNote X7 Tell me what you want to do 9. I Aalbot Aalbot AaBb T Normal 1 No Space Healing AaBbc AaB Aabel laber Aalber AaBbce Heading 2 Title Subtitle Subtle Em E mphasis intense Problem 4) Operating budget for a manufacturing company Comfort Furniture Corp. manufacturers and sells two types of tables: Regular and Deluxe In July 2017, the company's budget department gathered the following data to prepare 2018 budget. Direct Materials used to produce...
,Inc., manufactures and sells snowboards. Skis manufactures a single model, the Pipex. In late 2017 Ski management accountant gathered the following data to prepare budgets for January 2018 The inventoriable unit cost for ending finished goods inventory on December 31, 2017, is $230.00 Assume Skis uses a FIFO inventory method for both direct materials and finished goods. Ignore work in process in your calculations. Materials and Labor Requirements Direct materials Wood 17 board feet (b.f.) per snowboard Fiberglass 15 yards...