Blue Spruce Company expects to have a cash balance of $45,100 on January 1, 2022. Blue Spruce has budgeted the following for the first two months of the year 2022: Collections from customers: January $89,900: February $109,500. Payments to suppliers: January $40,000: February $50,300. Direct labour: January $29.900, February $34,900. Wages are paid in the month they are incurred. 4 Manufacturing overhead: January $24,800, February $30,300. Overhead costs are paid as incurred. Selling and administrative expenses: January $16,000; February $22,100. These costs do not include depreciation and they are paid as incurred. 1. 2 3. 5 6. Sales of investments in January are expected to realize $10.100 in cash. Blue Spruce Company wants to keep a minimum monthly cash balance of $20,000. Ignore any interest on amounts borrowed. Prepare a cash budget for January and February. BLUE SPRUCE COMPANY Cash Budget For 2022 $ January THOMA S February 111

Blue Spruce Company expects to have a cash balance of $45,100 on January 1, 2022. Blue Spruce has budgeted the following for the first two months of the year 2022: Collections from customers: January $89,900: February $109,500. Payments to suppliers: January $40,000: February $50,300. Direct labour: January $29.900, February $34,900. Wages are paid in the month they are incurred. 4 Manufacturing overhead: January $24,800, February $30,300. Overhead costs are paid as incurred. Selling and administrative expenses: January $16,000; February $22,100. These costs do not include depreciation and they are paid as incurred. 1. 2 3. 5 6. Sales of investments in January are expected to realize $10.100 in cash. Blue Spruce Company wants to keep a minimum monthly cash balance of $20,000. Ignore any interest on amounts borrowed. Prepare a cash budget for January and February. BLUE SPRUCE COMPANY Cash Budget For 2022 $ January THOMA S February 111

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter4: Financial Planning And Forecasting

Section: Chapter Questions

Problem 5P

See similar textbooks

Similar questions

Pilsner Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: Pilsner typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?
A company estimates its manufacturing overhead will be $840,000 for the next year. What is the predetermined overhead rate given each of the following Independent allocation bases? Budgeted direct labor hours: 90,615 Budgeted direct labor expense: $750000 Estimated machine hours: 150,000
Bonita Company expects to have a cash balance of $52,200 on January 1, 2022. Relevant monthly budget data for the first 2 months of 2022 are as follows. Collections from customers: January $98,600, February $174,000. Payments for direct materials: January $58,000, February $87,000. Direct labor: January $34,800, February $52,200. Wages are paid in the month they are incurred. Manufacturing overhead: January $24,360, February $29,000. These costs include depreciation of $1,740 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $17,400, February $23,200. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $13,920 in cash. Bonita Company has a line of credit at a local bank that enables it to borrow up to $29,000. The company wants to maintain a minimum monthly cash balance of $23,200.Prepare a cash budget for January and February.…
Lily Company expects to have a cash balance of $49,500 on January 1, 2022. Relevant monthly budget data for the first 2 months of 2022 are as follows. Collections from customers: January $93,500, February $165,000. Payments for direct materials: January $55,000, February $82,500. Direct labor: January $33,000, February $49,500. Wages are paid in the month they are incurred. Manufacturing overhead: January $23,100, February $27,500. These costs include depreciation of $1,650 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $16,500, February $22,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $13,200 in cash. Lily Company has a line of credit at a local bank that enables it to borrow up to $27,500. The company wants to maintain a minimum monthly cash balance of $22,000. Prepare a cash budget for January and February. LILY COMPANY Cash Budget…
Coronado Company expects to have a cash balance of $41,400 on January 1, 2022. Relevant monthly budget data for the first 2 months of 2022 are as follows. Collections from customers: January $78,200, February $138,000. Payments for direct materials: January $46,000, February $69.000. Direct labor: January $27,600, February $41,400, Wages are paid in the month they are incurred. Manufacturing overhead: January $19,320, February $23,000. These costs include depreciation of $1,380 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $13,800, February $18,400. These costs are exclusive of depreciation. They are paid as Incurred. Sales of marketable securities in January are expected to realize $11.040 in cash, Coronado Company has a line of credit at a local bank that enables it to borrow up to $23,000. The company wants to maintain a minimum monthly cash balance of $18,400. Prepare a cash budget for January and February. CORONADO COMPANY…
Crane Company expects to have a cash balance of $36,000 on January 1,2022. Relevant monthly budget data for the first 2 months of 2022 are as follows. Collections from customers: January $68,000, February $120,000.Payments for direct materials: January $40,000, February $60,000.Direct labor: January $24,000, February $36,000. Wages are paid in the month they are incurred.Manufacturing overhead: January $16,800, February $20,000. These costs include depreciation of $1,200 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $12,000, February $16,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $9,600 in cash. Crane Company has a line of credit at a local bank that enables it to borrow up to $20,000. The company wants to maintain a minimum monthly cash balance of $16,000. Prepare a cash budget for January and February. ReceiptsCollections from…
Bramble Company expects to have a cash balance of $43,200 on January 1, 2022. Relevant monthly budget data for the first 2 months of 2022 are as follows. Collections from customers: January $81,600, February $144,000. Payments for direct materials: January $48,000, February $72,000. Direct labor: January $28,800, February $43,200. Wages are paid in the month they are incurred. Manufacturing overhead: January $20,160, February $24,000. These costs include depreciation of $1,440 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $14,400, February $19,200. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $11.520 in cash. Bramble Company has a line of credit at a local bank that enables it to borrow up to $24,000. The company wants to maintain a minimum monthly cash balance of $19,200. Prepare a cash budget for January and February.
D’s Company Ltd expects to have a cash balance of $45000 on March 1, 2024.Relevant monthly budget data for the months of March and April are as follows:• Collections from customers: March $85000; April $150000• Payments for direct materials: March $50000; April $75000• Direct labour: March $30000; April $45000. Wages are paid in the month they are incurred.• Manufacturing overhead: March $21000; April $25000. These costs include depreciation of$1500 per month. All other overhead costs are paid as incurred.• Selling and administrative expenses: March $15000; April $20000. These costs are exclusive ofdepreciation. They are paid as incurred.• Sales of marketable securities in March are expected to be realised $12000 in cash.D’s Company Ltd. has a line of credit at a local bank that enables it to borrow up to$25000. Thecompany wants to maintain a minimum monthly cash balance of $20000. prepare cash budgets for march n april 2024
Automatic Irrigation, Inc. is preparing its manufacturing overhead budget for the 2022 year. Relevant data consist of the following: Qtr. 4 Qtr. 1 Qtr. 2 Qtr. 3 Control Units to be produced (by quarters): 6,000 10,000 12,000 9,000 Direct labor time: 1 hour per unit Variable overhead costs per direct labor hour: Indirect Materials $0.90; Indirect Labor $1.40; and Maintenance $0.50. Fixed overhead costs per quarter: Supervisory salaries $27,600; depreciation $4,000; and maintenance $1,900. Required Prepare the manufacturing overhead budget for the 2022 year showing quarterly data.
Danner Company expects to have a cash balance of $48,150 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Collections from customers: January $90,950, February $160,500. Payments for direct materials: January $53,500, February $80,250. Direct labor: January $32,100, February $48,150. Wages are paid in the month they are incurred. Manufacturing overhead: January $22,470, February $26,750. These costs include depreciation of $1,605 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $16,050, February $21,400. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $12,840 in cash. Danner Company has a line of credit at a local bank that enables it to borrow up to $26,750. The company wants to maintain a minimum monthly cash balance of $21,400.Prepare a cash budget for January and February.…
Ivanhoe Company expects to have a cash balance of $51,750 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Collections from customers: January $97,750, February $172,500. Payments for direct materials: January $57,500, February $86,250. Direct labor: January $34,500, February $51,750. Wages are paid in the month they are incurred. Manufacturing overhead: January $24,150, February $28,750. These costs include depreciation of $1,725 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $17,250, February $23,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $13,800 in cash. Ivanhoe Company has a line of credit at a local bank that enables it to borrow up to $28,750. The company wants to maintain a minimum monthly cash balance of $23,000. Prepare a cash budget for January and February. IVANHOE COMPANY Cash…
Domino Consulting, budgeted overhead and other expenses as follows for the year ended December 31, 2023: Overhead: Rent $ 25,000 Repairs 10,000 Fuel 35,000 Maintenance 15,750 Supplies 6,100 Heat and light 20,250 Depreciation-computer 9,400 Miscellaneous 6,000 Depreciation-building 18,000 Depreciation-equipment…