Concept explainers
Completing a comprehensive budgeting problem—manufacturing company
Learning Objectives 3, 4
1. 3rd Qtr. DM purchases $34,680
4th Qtr. total cash pmts. (before interest) $87,159
The Gerard Tire Company manufactures racing tires for bicycles. Gerard sells tires for $90 each. Gerard is planning for the next year by developing a
GERARD TIRE COMPANYBalance SheetDecember 31, 2018 | ||
Assets | ||
Current Assets: | ||
Cash | $56,000 | |
Accounts Receivable | 20,000 | |
Raw Materials Inventory | 5,100 | |
Finished Goods Inventory | 9,900 | |
Total Current Assets | $91,000 | |
Property, Plant, and Equipment: | ||
Equipment | 194,000 | |
Less: |
(42,000) | 152,000 |
Total Assets | $243,000 | |
Liabilities | ||
Current Liabilities: | ||
Accounts Payable | $8,000 | |
Common Stock, no par | $120,000 | |
115,000 | ||
Total Stockholders’ Equity | 235,000 | |
Total Liabilities and Stockholders’ Equity | $243,000 |
Other data for Gerard Tire Company:
a. Budgeted sales are 1,500 tires for e first quarter and expected to increase by 200 tires per quarter. Cash sales are expected to be 10% of total sales, with the remaining 90% of sales on account.
b. Finished Goods inventory on December 31, 2018, consists of 300 tires at $33 each.
c. Desired ending Finished Goods Inventory 30% of the next quarter’s sales; first quarter sales for 2020 are expected to be 2,300 tires. FIFO inventory costing method is used.
d. Raw Materials Inventory on Decenter 31, 2018, consists of 600 pounds of rubber compound used to manufacture the tires.
e. Direct materials requirements are 2 pounds of a rubber compound per tire. The cost of the compound is $8.50 per pound.
f. Desired ending Raw Material Inventory 40% of the next quarter’s direct materials needed for production; desired ending inventory for December 31, 2019 is 600 pounds; indirect materials are insignificant and not considered for budgeting purposes.
g. Each tire requires 0.4 hours of directed labor; direct labor costs average $12 per hour.
h. Variable manufacturing overhead $4 per tire.
i. Fixed manufacturing overhead includes $6,000 per quarter in depreciation and $16,770 per quarter for other costs, such as utilities, insurance, and property taxes.
j. Fixed selling and administrative expenses include $12,500 per quarter for salaries; $3,000 per quarter for rent; $450 per quarter for insurance; and $2,000 per quarter for depreciation.
k. Variable selling and administrative expenses include supplies at 2% of sales.
l. Capital expenditure include $15,000 for new manufacturing equipment, to be purchased and paid in the first quarter.
m. Cash receipts for sales on account are 70% in the quarter of the sale and 30% in the quarter following the sale; December 31, 2018, Accounts Receivable is received in the first quarter of 2019; uncollectible accounts are considered insignificant and not considered for budgeting purposes.
n. Diret materials purchases are paid 60% in the quarter purchased and 40% in the following quarter, December 31, 2018, Accounts Payable is paid in the first quarter of 2019.
o. Direct labor, manufacturing overhead, and selling and administrative costs are paid in the quarter incurred.
p. Income tax expense is projected at $1,500 per quarter and is paid in the quarter incurred..
q. Gerard desires to maintain a minimum cash balance of $55,000 and borrows from the local bank as needed in increments of $1,000 at the beginning of the quarter; principal repayments are made at the beginning of the quarter when excess funds are available and in increments of $1,000; interest is 6% per year and paid at the beginning of the quarter based on the amount outstanding from the previous quarter.
Requirements
1. Prepare Gerard’s operating budget and
2. Prepare Gerard’s annual financial budget for 2019, including budgeted come statement and budgeted balance sheet.
Want to see the full answer?
Check out a sample textbook solutionChapter 22 Solutions
Horngren's Accounting, Student Value Edition (12th Edition)
- task 1 Prepare the following budgets for the year 2021: - a. Sales budget. Show total sales by quarter and in total for the year. b. Production budget. Show total production unit by quarter and in total for the year. c. Direct material usage and purchase budget. d. Direct labour budget. task 2 Based Jaka’s experience, fifty percent (50%) of sales are paid in cash. Of the sales on account, seventy percent (70%) are collected in the quarter of sale; the remaining thirty percent (30%) are collected in the quarter following the sale. Total sales for the fourth quarter of 2020 totaled RM2,000,000. Required: Refer to the sales budget prepared in Task 1. Construct a cash receipts budget including an accounts receivable aging schedule for Jaka Sdn Bhd for each quarter of year 2021.arrow_forwardtask 1 Prepare the following budgets for the year 2021: - a. Sales budget. Show total sales by quarter and in total for the year. d. Direct labour budget. task 2 Based Jaka’s experience, fifty percent (50%) of sales are paid in cash. Of the sales on account, seventy percent (70%) are collected in the quarter of sale; the remaining thirty percent (30%) are collected in the quarter following the sale. Total sales for the fourth quarter of 2020 totaled RM2,000,000. Required: Refer to the sales budget prepared in Task 1. Construct a cash receipts budget including an accounts receivable aging schedule for Jaka Sdn Bhd for each quarter of year 2021.arrow_forwardCase Study for Slopes Company.Comprehensive operating budget. Slopes, Inc., manufactures and sells snowboards. Slopesmanufactures a single model, the Pipex. In the summer of 2018, Slope’s accountant gatheredthe following data to prepare budgets for 2019:Materials and labor requirementsDirect materials:Wood 5 board feet per snowboardFiberglass 6 yards per snowboardDirect manufacturing labor 5 hours per snowboardSlopes’ CEO expects to sell 1,000 snow boards during 2019 at an estimated retail price ofRM 450 per board. Further, he expects 2019 beginning inventory of 100 boards, and would liketo end 2019 with 200 snowboards in stock.Direct materials inventoriesBeginning Inventory Ending Inventory1/1/2019 12/31/2019________________________________________________________Wood 2,000 1,500Fiberglass 1,000 2,000Variable manufacturing overhead is allocated is allocated at the rate RM 7 per directmanufacturing labor-hour. There are also RM 66,000 in fixed manufacturing overhead costsbudgeted for…arrow_forward
- Case Study for REX Company.Comprehensive operating budget. REX, Inc., manufactures and sells snowboards. REXmanufactures a single model, the Pipex. In the summer of 2018, REXS accountant gatheredthe following data to prepare budgets for 2019:Materials and labor requirementsDirect materials:Wood 5 board feet per snowboardFiberglass 6 yards per snowboardDirect manufacturing labor 5 hours per snowboardREX’ CEO expects to sell 1,000 snow boards during 2019 at an estimated retail price of$ 450 per board. Further, he expects 2019 beginning inventory of 100 boards, and would liketo end 2019 with 200 snowboards in stock.Direct materials inventories Beginning Inventory Ending Inventory1/1/2019 12/31/2019________________________________________________________Wood 2,000 1,500Fiberglass 1,000 2,000Variable manufacturing overhead is allocated is allocated at the rate $ 7 per directmanufacturing labor-hour. There are also $ 66,000 in fixed manufacturing overhead costsbudgeted for 2019.REX combines…arrow_forwardCompleting a comprehensive budgeting problem—manufacturing company The Gerard Tire Company, manufactures racing tires for bicycles. Gerard sells tires for $90 each. Gerard is planning for the next year by developing a master budget by quarters. Gerard’s balance sheet for December 31, 2018, follows: Other data for Gerard Tire Company: Budgeted sales are 1,500 tires for the first quarter and expected to increase by 200 tires per quarter. Cash sales are expected to be 10% of total sales, with the remaining 90% of sales on account. Finished Goods Inventory on December 31, 2018, consists of 300 tires at $33 each. Desired ending Finished Goods Inventory is 30% of the next quarter’s sales; first quarter sales for 2020 are expected to be 2,300 tires. FIFO inventory costing method is used. Raw Materials Inventory on December 31, 2018, consists of 600 pounds of rubber compound used to manufacture the tires. Direct materials requirements are 2 pounds of a rubber compound per tire. The cost of…arrow_forwardCompleting a comprehensive budgeting problem—merchandising company Belton Printing Company of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for the month of April 2018 and a balance sheet at April 30, 2018. The March 31, 2018a balance sheet follows: As Belton Printings controller, you have assembled the following additional information: April dividends of $7,000 were declared and paid. April capital expenditures of $17,000 budgeted for cash purchase of equipment. April depreciation expense, $800. Cost of goods sold, 55% of sales. Desired ending inventory For April is $24,800. April selling and administrative expenses includes salaries of $29,000, 20% of which Will be paid in cash and the remainder paid next month. Additional April selling and administrative expenses also include miscellaneous expenses of 10% of sales, all paid in April. April budgeted sales, $86,000, 80% collected in April and 20% in May. April cash payments of March 31…arrow_forward
- Completing a comprehensive budgeting problem—merchandising Company Alliance Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2018 and a balance sheet at April 30, 2018. The March 31, 2018, balance sheet follows: As Alliance Printing Supply’s controller, you have assembled the following additional information: April dividends of $7,000 were declared and paid. April capital expenditures of $16,300 budgeted for cash purchase of equipment. April depreciation expense, $1,000. Cost of goods sold, 40% of sales. Desired ending inventory for April is $22,400. April selling and administrative expenses include salaries of $37,000, 30% of which will be paid in cash and the remainder paid next month. Additional April selling and administrative expenses also include miscellaneous expenses of 10% of sales, all paid in April. April budgeted sales, $89,000, 80% collected in April and 20°/0 in May. April cash payments of March 31…arrow_forwardPreparing a financial budget—schedule of cash receipts and schedule of cash payments</b></p><p>Agua Cool is a distributor of bottled water. For each of the items, compute the number of cash receipts or payments Agua Cool will budget for September. The solution to one item may depend on the answer to an earlier item. Management expects to sell equipment that cost $14,000 at a gain of $7,000. Accumulated depreciation on this equipment is $55,000. Management expects to sell 7,100 cases of water in August and 9,000 cases in September. Each case sells for $14. Cash sales average 20% of total sales, and credit sales make up the rest. Three-fourths of credit sales are collected in the month of the sale, with the balance collected the following month. The company pays rent and property taxes of $4,500 each month. Commissions and other selling expenses average 30% of sales. Agua Cool pays one—half of the commissions and other selling expenses in the month incurred, with the…arrow_forwardMULTI COLORED PICTURE ATTACHED IS THE PART I NEED HELP WITH SECOND IS PART OF THE INFORMATION GIVEN WITH THE QUESTION The Grady Tire Company manufactures racing tires for bicycles. Grady sells tires for $70 each. Grady is planning for the next year by developing a master budget by quarters. Grady's balance sheet for Decembe 31,2018, follows: a. Budgeted sales are 1,800 tires for the first quarter and expected to increase by 50 tires per quarter. Cash sales are expected to be 20% of total sales, with the remaining 80% of sales on account. b. Finished Goods Inventory on December 31, 2018 consists of 100 tires at $36 each. c. Desired ending Finished Goods Inventory is 50% of the next quarter's sales; first quarter sales for 2020 are expected be 2,000 tires. FIFO inventory costing method is used. d. Raw Materials Inventory on December 31, 2018, consists of 200 pounds of rubber compound used to manufacture the tires. e. Direct materials requirements are 2 pounds of a rubber compound…arrow_forward
- E9-26A Budgeted income statement (Learning Objective 2) Delta Labs performs a specialty lab test for local companies for $45 per test. For the upcoming quarter, Delta Labs is projecting the following sales: January February March Number of lab tests 5,600 4,900 5,700 The budgeted cost of performing each test is $21. Operating expenses are projected to be $59,000 in January, $57,000 in February, and $58,000 in March. Delta Labs is subject to a corporate tax rate of 30%. Requirement Prepare a budgeted income statement for the first quarter, with a column for each month and for the quarter.arrow_forwardLearning Objective 2 Product Costs and Product Profitability Reports, using a Single Plantwide Factory Overhead Rate Isaac Engines Inc. produces three products-pistons, valves, and cams-for the heavy equipment industry. Isaac Engines has a very simple production process and product line and uses a single plantwide factory overhead rate to allocate overhead to the three products. The factory overhead rate is based on direct labor hours. Information about the three products for 20Y2 is as follows: Pistons Valves Cams Budgeted Volume (Units) 6,000 13,000 1,000 Pistons Direct Labor Hours Per Unit Valves Cams If required, round all per unit answers to the nearest cent. a. Determine the plantwide factory overhead rate. $ 28 ✔per dlh 0.30 0.50 0.10 0.3 ✔ dlh The estimated direct labor rate is $20 per direct labor hour. Beginning and ending inventories are negligible and are, thus, assumed to be zero. The budgeted factory overhead for Isaac Engines is $235,200. 0.5 dlh 0.1 ✓dlh Price Per Unit…arrow_forwarding price of $26 per case. The following information relates to the budget for Main Street a flexible budget performance report (Learning Objective 5) Main Street Muffins sells its muffins to restaurants and coffee houses for an average sell- Muffins for this year (all figures are annual totals unless otherwise noted): Performance Evaluation 629 E10-26A Prepare Budgeted sales in cases 9,100 cases Packaging cost per case. %24 Shipping expense per case Sales commission expense. 2 5% of sales price Salaries expense.. $6,500 Office rent $3,900 Depreciation. $2,500 Insurance expense... $1,800 $ 900 Office supplies expense. During the year, Main Street Muffins actually sold 9,500 cases, resulting in total sales rev- enue of $255,200. Actual expenses (in total) from this year are as follows: Packaging cost. $ 10,600 $ 19,500 $ 12,760 $ 7,300 Shipping expense.. Sales commission expense. Salaries expense... $ 3,900 $ 2,500 $ 1,600 Office rent Depreciation. Insurance expense.. $ 1,600 Office…arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College