Question

COST ACCOUNTING Gizmos, Inc. incorporated and will begin operations on January 1, 2021. Its primary business...

COST ACCOUNTING

Gizmos, Inc. incorporated and will begin operations on January 1, 2021. Its primary business is the manufacture and sale of gadgets. Because cash resources are limited, the company anticipates the need to have access to capital during the first year of operations and seeks to establish a line of credit with a local bank. The bank requires a complete operating and cash budget and pro-forma financial statements for 2021 as part of the loan application.

The following information and data are to be used in preparing the budget.

  1. 1) Gizmos, Inc. is a closely-held corporation. The original owners will invest an initial $150,000 (assume the initial cash funding occurs on January 1, 2021) to establish the corporation and are the only shareholders of the company.

  2. 2) Production equipment totaling $48,000 will be purchased on January 2, 2021 and put into immediate use. The equipment has an expected useful life of five years, with no salvage value. It will be depreciated using straight-line depreciation method.

  3. 3) The sole product is the Standard Gizmo. Each unit requires four pounds of raw material. The cost of the raw material is $0.50 per pound. It takes six minutes of direct labor to produce one gadget. Direct labor employees are paid $18.00 per hour.

  4. 4) Monthly fixed and variable overhead and selling & administrative (S&A) expenses are estimated below. Fixed manufacturing overhead is allocated on the basis of direct labor hours.

VARIABLE    FIXED

Manufacturing overhead (including depreciation) 30% of direct labor costs $20,000

Selling & Administrative Expenses $0.40 per unit sold    $6,000

  1. 5) Gizmos will sell for $8.05 each. January sales are expected to be 8,000 units. Demand is expected to increase by 500 units per month until a level of 12,000 units per month is reached.

  2. 6) Gizmos, Inc.’s inventory policy establishes the following required monthly ending inventory levels:

    •  Finished Goods: Maintain an ending inventory equal to one-half of the following month's expected sales.

    •  Raw Materials: Maintain an ending inventory quantity equal to three-fourths of the materials needed for the next month's production.

    •  Work-in-Process: Assume the month-end inventory is zero.

2

  1. 7) All sales are made to established credit customers with credit terms of net 90 days. No sales discounts are offered for early payment. Twenty percent (20%) of payments for credit sales are expected to be received in the first month subsequent to the month of sale. Another sixty percent (60%) of payments are expected to be received in the second month after the sale. The remaining twenty percent (20%) of payments are expected to be received in the third month subsequent to the sale. (As an example, if January sales are $10,000, the company expects to receive payments of $2,000, $6,000 and $2,000 in February, March and April, respectively.)

  2. 8) Gizmos, Inc. has a credit arrangement with its raw materials vendor and purchases all materials on account with a basic invoice term of net 60 days. The company receives NO cash discounts for early payment of invoices. Gizmos pays 60% of its raw materials purchases in the month of purchase. The remaining 40% is paid in the first month subsequent to the purchase.

  3. 9) All other operating expenses will be paid in the month incurred.

  4. 10) The income tax rate is 24%. Estimated tax payments are made to the US Treasury on the last day of each quarter. Each quarterly payment is $5,000. Any balance due at year-end is recorded as a liability on the balance sheet. If taxes have been overpaid, the estimated refund is recorded as a receivable on the balance sheet.

  5. 11) The company requires a minimum ending monthly cash balance of $2,000 which must be reflected in the cash budget.

  6. 12) The proposed funding agreement with the bank is a line of credit of up to $100,000, effective January 1, 2021. The annual interest rate on the line of credit is 4%, payable on the last day of each month on the outstanding loan balance.

    In any month that the cash budget indicates ending monthly cash balance less than the required minimum cash balance; the company will borrow against the line of credit an amount sufficient to bring the ending cash balance up to the required $2,000 minimum. If the ending monthly cash balance is greater than the $2,000 required minimum, the excess cash will be used to repay the outstanding balance. Borrowings and repayments throughout the year will be budgeted in increments of $100. However, the company will budget for a final December payment that will reduce the line of credit balance to zero. Borrowing and repayments will occur on the last day of the month (not affecting the month end calculation of interest payment due that day.)

3:

Create the 2021 monthly master budgets for Gizmos, Inc. in Microsoft Excel. The elements of the master budget include both the operating budget and the financial budget.

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Zen, Inc. is a merchandiser of herbal teas and begin operations on January 1. The company...
Zen, Inc. is a merchandiser of herbal teas and begin operations on January 1. The company expects sales in its first month of operations to total $2,500. All sales will be cash sales. Inventory purchases during January are expected to equal $600. Purchases are paid for in the month following the month of purchase. No purchase discounts are available. Zen's expected monthly operating expenses are $1,750, $500 of which is for depreciation. No timing differences exist between when cash operating...
Part A. Wally's widgets is starting operations as of January 1. The company sells a single...
Part A. Wally's widgets is starting operations as of January 1. The company sells a single product and expects first month's sales to be 10,000 units with sales increasing by 250 units per month thereafter. the sales price for the product is $12.00. The company has a 50% gross margin on its products and pays a 10% commission on sales -What is the budget assumption for First month's sales in Units, Sales Growth per month, Sales price per unit, Gross...
Danner Company expects to have a cash balance of $45,000 on January 1, 2020. Relevant monthly...
Danner Company expects to have a cash balance of $45,000 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Prepare a cash budget for 2 months. Collections from customers: January $85,000, February $150,000. Payments for direct materials: January $50,000, February $75,000. Direct labor: January $30,000, February $45,000.Wages are paid in the month they are incurred. Manufacturing overhead: January $21,000, February $25,000. These costs include depreciation of $1,500 per month. All other...
Danner Company expects to have a cash balance of $46,800 on January 1, 2020. Relevant monthly...
Danner Company expects to have a cash balance of $46,800 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Collections from customers: January $88,400, February $156,000. Payments for direct materials: January $52,000, February $78,000. Direct labor: January $31,200, February $46,800. Wages are paid in the month they are incurred. Manufacturing overhead: January $21,840, February $26,000. These costs include depreciation of $1,560 per month. All other overhead costs are paid as incurred....
Danner Company expects to have a cash balance of $59,040 on January 1, 2017. Relevant monthly...
Danner Company expects to have a cash balance of $59,040 on January 1, 2017. Relevant monthly budget data for the first 2 months of 2017 are as follows. Collections from customers: January $111,520, February $196,800. Payments for direct materials: January $65,600, February $98,400. Direct labor: January $39,360, February $59,040. Wages are paid in the month they are incurred. Manufacturing overhead: January $27,552, February $32,800. These costs include depreciation of $1,968 per month. All other overhead costs are paid as incurred....
apcaplett, Inc. has the following budgeted income statement for January and February: January February Revenues $1,200,000...
apcaplett, Inc. has the following budgeted income statement for January and February: January February Revenues $1,200,000 $1,100,000 Direct Materials 220,000 202,000 Other Variable COGS 140,000 128,000 Fixed COGS 300,000 300,000 Gross Margin $ 540,000 $ 470,000 Period Costs (Fixed) 380,000 380,000 Income $ 160,000 $ 90,000 Wapcaplett has noticed the following trends: 20% of all sales are in cash, and the other 80% are credit sales. Credit sales are collected 75% in the month of the sale and 25% in...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows:...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows: January February Sales $375,120 $416,800 Direct materials purchases 125,040 130,250 Direct labor 93,780 104,200 Manufacturing overhead 72,940 78,150 Selling and administrative expenses 82,318 88,570 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct materials purchases...
1 Master budget                                        
1 Master budget                                                                                                                                   60 points ABC Company requests you to prepare a budget for the third quarter ending September 30 2020. You are required to prepare the following budgets: Sales Sales receipt schedule Production Purchases Materials payment schedule Labor Overheads General admin and selling Capital Cash Sales Budget Budgeted sales of the company's product for the month of June was 28,000 units at $5/unit: It is anticipated that sales units will grow by 5% monthly from the previous month's...
The following information relates to Rebel a retail business sport equipment. The table below provides the...
The following information relates to Rebel a retail business sport equipment. The table below provides the sales and purchases for the company: Actual Sales Actual Purchases October 2019 $38,000 $20,000 November 2019 $41,000 $24,000 December 2019 $48,500 $29,800 Budgeted Sales Budgeted Purchases January 2020 $54,000 $32,000 Additional information includes: Cash sales are 20% each month. Credit sales are expected to be collected 60% one month after sale, 20% two months after the sale and 15% 3 months after the month...
1- If there were 50000 pounds of raw materials on hand on January 1, 120000 pounds...
1- If there were 50000 pounds of raw materials on hand on January 1, 120000 pounds are desired for inventory at January 31, and 500000 pounds are required for January production, how many pounds of raw materials should be purchased in January? 2- The production budget shows expected unit sales of 22000. Beginning finished goods units are 3200. Required production units are 23600. What are the desired ending finished goods units? 3- The direct materials budget shows: Units to be...