Unit sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total | |
21.5 Bike | 368 | 472 | 633 | 616 | 443 | 345 | 322 | 317 | 317 | 317 | 328 | 420 | 4898 | 385 |
22.5 Bike | 320 | 410 | 550 | 535 | 385 | 300 | 280 | 275 | 275 | 275 | 285 | 365 | 4255 | 350 |
Total units | 688 | 882 | 1183 | 1151 | 828 | 645 | 602 | 592 | 592 | 592 | 613 | 785 | 9153 | |
Total Sales $ | ||||||||||||||
$ 455/21.5 Bike | 167440 | 214760 | 288015 | 280280 | 201565 | 156975 | 146510 | 144235 | 144235 | 144235 | 149240 | 191100 | 2228590 | |
$ 490/22.5 Bike | 156800 | 200900 | 269500 | 262150 | 188650 | 147000 | 137200 | 134750 | 134750 | 134750 | 139650 | 178850 | 2084950 | |
Total Bud.Sales $ | 324240 | 415660 | 557515 | 542430 | 390215 | 303975 | 283710 | 278985 | 278985 | 278985 | 288890 | 369950 | 4313540 |
Actual desired End.Inv.of the foll.mth. Sales units | |||||||||||||
21.5 Bike(15%) | 70.8 | 95.0 | 92.4 | 66.5 | 51.8 | 48.3 | 47.6 | 47.6 | 47.6 | 49.2 | 63.0 | 57.8 | 57.8 |
22.5 Bike(12%) | 49.2 | 66.0 | 64.2 | 46.2 | 36.0 | 33.6 | 33.0 | 33.0 | 33.0 | 34.2 | 43.8 | 42.0 | 42.0 |
Rounded desired End.Inv.of the foll.mth. Sales units | |||||||||||||
21.5 Bike(15%) | 71 | 95.0 | 93 | 67 | 52 | 49 | 48 | 48 | 48 | 50 | 63 | 58 | 58.0 |
22.5 Bike(12%) | 50 | 66.0 | 65 | 47 | 36 | 34 | 33 | 33 | 33 | 35 | 44 | 42 | 42.0 |
Production Budget | |||||||||||||
21.5 Bike sales | 368 | 472 | 633 | 616 | 443 | 345 | 322 | 317 | 317 | 317 | 328 | 420 | 4898 |
22.5 Bike sales | 320 | 410 | 550 | 535 | 385 | 300 | 280 | 275 | 275 | 275 | 285 | 365 | 4255 |
21.5 Bike(Des. E/I)) | 71 | 95.0 | 93 | 67 | 52 | 49 | 48 | 48 | 48 | 50 | 63 | 58 | 58.0 |
22.5 Bike(Des.E/I) | 50 | 66.0 | 65 | 47 | 36 | 34 | 33 | 33 | 33 | 35 | 44 | 42 | 42.0 |
21.5 Bike(Tot.Inv.reqd.) | 439 | 567 | 726 | 683 | 495 | 394 | 370 | 365 | 365 | 367 | 391 | 478 | 4956 |
22.5 Bike sales(Tot.Inv.reqd.) | 370 | 476 | 615 | 582 | 421 | 334 | 313 | 308 | 308 | 310 | 329 | 407 | 4297 |
Less: 21.5 Bike(Beg.Inv.) | 55 | 71 | 95 | 93 | 67 | 52 | 49 | 48 | 48 | 48 | 50 | 63 | 55 |
Less:22.5 Bike sales(Beg.Inv.) | 38 | 50 | 66 | 65 | 47 | 36 | 34 | 33 | 33 | 33 | 35 | 44 | 38 |
21.5 Bike (units to produce) | 384 | 496 | 631 | 590 | 428 | 342 | 321 | 317 | 317 | 319 | 341 | 415 | 4901 |
22.5 Bike (units to produce) | 332 | 426 | 549 | 517 | 374 | 298 | 279 | 275 | 275 | 277 | 294 | 363 | 4259 |
Fixed Overhead | |||||||||||||
Salaries | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 60000 |
Utilities | 2200 | 2200 | 2200 | 2200 | 2200 | 2200 | 2200 | 2200 | 2200 | 2200 | 2200 | 2200 | 26400 |
Depreciation | 7200 | 7200 | 7200 | 7200 | 7200 | 7200 | 7200 | 7200 | 7200 | 7200 | 7200 | 7200 | 86400 |
Maintenance | 2800 | 2800 | 2800 | 2800 | 2800 | 2800 | 2800 | 2800 | 2800 | 2800 | 2800 | 2800 | 33600 |
Insurance | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 24000 |
Property taxes | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 14400 |
Total Fixed OH | 20400 | 20400 | 20400 | 20400 | 20400 | 20400 | 20400 | 20400 | 20400 | 20400 | 20400 | 20400 | 244800 |
S G& A | |||||||||||||
Bud. sales units | 688 | 882 | 1183 | 1151 | 828 | 645 | 602 | 592 | 592 | 592 | 613 | 785 | 9153 |
Variable sg&A rate | 11.2 | 11.2 | 11.2 | 11.2 | 11.2 | 11.2 | 11.2 | 11.2 | 11.2 | 11.2 | 11.2 | 11.2 | 11.2 |
Variable sg&A exp. | 7706 | 9878 | 13250 | 12891 | 9274 | 7224 | 6742 | 6630 | 6630 | 6630 | 6866 | 8792 | 102514 |
Fixed SG&A exp. | 18000 | 18000 | 18000 | 18000 | 18000 | 18000 | 18000 | 18000 | 18000 | 18000 | 18000 | 18000 | 216000 |
Total SG&A exp. | 25706 | 27878 | 31250 | 30891 | 27274 | 25224 | 24742 | 24630 | 24630 | 24630 | 24866 | 26792 | 318514 |
Less: Non-cash sg&a | 7800 | 7800 | 7800 | 7800 | 7800 | 7800 | 7800 | 7800 | 7800 | 7800 | 7800 | 7800 | 93600 |
Cash sg&a | 17906 | 20078 | 23450 | 23091 | 19474 | 17424 | 16942 | 16830 | 16830 | 16830 | 17066 | 18992 | 224914 |
Ending Inventory Budget | |||||||||||||
21.5 Bike(Des. E/I)) | 71 | 95 | 93 | 67 | 52 | 49 | 48 | 48 | 48 | 50 | 63 | 58 | 58 |
22.5 Bike(Des.E/I) | 50 | 66 | 65 | 47 | 36 | 34 | 33 | 33 | 33 | 35 | 44 | 42 | 42 |
21.5 Bike $ Raw mat.*164.45 | 16313 | 20754 | 19405 | 14077 | 11248 | 10558 | 10426 | 10426 | 10492 | 11215 | 13649 | 15700 | 15700 |
22.5 Bike$ Raw mat.*186.30 | 15873 | 20456 | 19263 | 13935 | 11103 | 10396 | 10247 | 10247 | 10321 | 10954 | 13525 | 15300 | 15300 |
Scenario: Styles Wing Bicycle Company manufactures and sells 2 sizes of bicycles, 21.5 inch and 22.5...
Jonus Bike Inc., manufactures and sells high-end bicycles. Each bicycle that the company sells comes with a 5 year unlimited warranty. Based on past experience, Jonus' accountant estimates that for every $4,000 worth of sales, Jonus will have to pay out $61 in warranty costs. Do not enter dollar signs or commas in the input boxes. a) This year, Jonus Bike Inc. had sales of $1,320,000. First, calculate the estimated warranty costs based on the accountant's analysis. Date Account Title...
The Giseppe Tire Company manufactures racing tires for bicycles. sells tires for $80 each. Giseppe is planning for the next year by developing a master budget by quarters. balance sheet for follows Requirements: 1.Prepare Giseppe'operating budget and cash budget for 2019 by quarter. Required schedules and budgets include: sales budget, production budget, direct materials budget, direct labor budget, manufacturing overhead budget, cost of goods sold budget, selling and administrative expense budget, schedule of cash receipts, schedule of cash payments, and...
Suppose Cook Plus manufactures cast iron skillets. One model is a 10-inch skillet that sells for $32. Cook Plus projects sales of 675 10-inch skilets per month. The production costs are $11 per skillet for direct materials, 55 per skillet for direct labor, and $3 per skillet for manufacturing overhead. Cook Plus has 40 10-inch skilets in inventory at the beginning of July but wants to have an ending inventory equal to 20% of the next month's sales. Selling and...
The Gridley Tire Company manufactures racing tires for bicycles. Gridley sells tires for $75 each Gridley is planning for the next year by developing a master budget by quarters. Gridley's balance sheet for December 31, 2018, follows (Click the icon to view the balance sheet) Other data for Gridley Tire Company i Clck he icon to view the other data) Read the repuiremens. Revew the sales budget you prepared above Cash Receipts from Customers Third First Second Fourth Quarter Quarter...
Master Budget Case: ToyWorks Ltd. ToyWorks Ltd. is a company that manufactures and sells a single product, which they call a toodle. For planning and control purposes they utilize a quarterly master budget, which is usually developed at least six months in advance of the budget period. Their fiscal year end is December 31. During the summer of 2018, Chris Leigh, the ToyWorks controller, spent considerable time with Pat Frazer, the Manager of Marketing, putting together a sales forecast for...
The Grady Tire Company manufactures racing tires for bicycles. Grady sells tires for $70 each. Grady is Other data for Grady Tire Com planning for the next year by developing a master budget by quarters. Grady's balance sheet for (Click the icon to view the December 31, 2018, follows: B (Click the icon to view the balance sheet.) Read the requirements Selling and Administrative Expense Budget For the Year Ended December 31, 2019 First Second Third Fourth Quarter Quarter Quarter...
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Janus Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July to October are as...
Add title, thank you! Hammerly Corporation is preparing its m March 31. It sells a single product for $25 a unit. Budgeted sales are 40 credit. All credit sales are collected in the month following the four months follow: y Corporation is preparing its master budget for the quarter ending es are collected in the month following the sales, Budgeted sales for the next 1. Budgeted sales are 40% cash and 60% on Sales in Units ..... January 1,200 February...
Scott Products Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Scott Products has had to borrow money during the third quarter to support peak sales of back- to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for for July through October...
Saved dget Project i Help Save The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash Accounts receivable Inventory Building and equipment, net Accounts payable Common stock Retained earnings $ 7,700 $ 20,800 $ 40, 800 $ 129,600 $ 24,300 $ 150,000 $ 24,600 a. The gross margin is 25% of sales. b. Actual and budgeted sales data: March (actual) April May June July $ 52,000 $...