Franklin Company, which expects to start operations on January 1, year 2, will sell digital cameras in shopping malls. Franklin has budgeted sales as indicated in the following table. The company expects a 11 percent increase in sales per month for February and March. The ratio of cash sales to sales on account will remain stable from January through March. Required a. Complete the sales budget by filling in the missing amounts. b. Determine the amount of sales revenue Franklin will report on its first quarter pro forma income statement. Complete this question by entering your answers in the tabs below. Required A Required B Complete the sales budget by filling in the missing amounts. (Do not round intermediate calculations. Round final answers to two decimal places.) Sales Cash sales Sales on account Total budgeted sales January $ $ 35,000 101,000 136,000 February March

Franklin Company, which expects to start operations on January 1, year 2, will sell digital cameras in shopping malls. Franklin has budgeted sales as indicated in the following table. The company expects a 11 percent increase in sales per month for February and March. The ratio of cash sales to sales on account will remain stable from January through March. Required a. Complete the sales budget by filling in the missing amounts. b. Determine the amount of sales revenue Franklin will report on its first quarter pro forma income statement. Complete this question by entering your answers in the tabs below. Required A Required B Complete the sales budget by filling in the missing amounts. (Do not round intermediate calculations. Round final answers to two decimal places.) Sales Cash sales Sales on account Total budgeted sales January $ $ 35,000 101,000 136,000 February March

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Assume a company is preparing a budget for its first two months of operations. During the first and second months it expects credit sales of $42,000 and $74,000, respectively. The company expects to collect 35% of its credit sales in the month of the sale and the remaining 65% in the following month. What amount of cash collections from credit sales would the company include in its cash budget for the second month?
Assume a company is preparing a budget for its first two months of operations. During the first and second months it expects credit sales of $40,000 and $77,000, respectively. The company expects to collect 30% of its credit sales in the month of the sale and the remaining 70% in the following month. What is the expected cash collections from credit sales during the first month?
BCAS Ltd is developing a cash budget for April, May and June 2022, and the following information was gathered: Cash Receipts 1 Sales revenue for February and March 2022 are $200,000 and $180,000 respectively. The forecasted sales revenue for April, May and June 2022 are $170,000, $220,000 and $280,000 respectively. Historically, 30% of the firm’s sales are in cash, 60% are collected in the next month, and the remaining 10% are collected in the second month following the sale. 2 Monthly rental income received is $60,000. 3 Interest income of $10,000 will be received in May 2022. Cash Disbursements 4 The expected purchases are $150,000, $110,000 and $190,000 for the months of April, May and June 2022 respectively. The company pays all its purchases in the month of purchase. 5 Monthly salaries paid is $70,000. 6 Commission is paid to its salesman at 2% of current month’s sales. 7 Renovation of all retail outlets amounting to $400,000…
Empire Records Incorporated is a music retail store that began operations on January 1, Year 1. The company has budgeted sales as indicated in the following table. The company expects a 5 percent increase in sales per month for February and March. The ratio of cash sales to sales on account will remain stable from January through March. The company expects 50% of the sales on account to be collected in the month of sale with the remaining 50% collected in the month following the sale. Required: a. Complete the sales budget by filling in the missing amounts. b. What are the expected total cash receipts for the month of February? Complete this question by entering your answers in the tabs below. Required A Required B Complete the sales budget by filling in the missing amounts. January February March Sales Budget Cash sales Sales on account Total budgeted sales $ 63,200 140,000 203,200 0 0 Required B >
Cash Budget Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: The company’s beginning cash balance for the upcoming fiscal year will be $20,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank, at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. Required: Using Schedule 8 as your guide, prepare the company’s cash budget for the upcoming fiscal year.
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2022 are as follows. Sales Direct materials purchases Direct labor Manufacturing overhead Selling and administrative expenses Other data: 1. 2. 3. January February $360,000 $400,000 125,000 100,000 4. 120,000 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 are paid in cash in the month of purchase, and the balance due is paid in the month following the purchase. All other items above are paid in the month incurred except for selling and administrative expenses that include $1,000 of depreciation per month. 90,000 70,000 79,000 75,000 85,000 Credit sales: November 2021, $250,000; December 2021, $320,000. Purchases of direct materials: December 2021, $100,000. Other receipts: January-Collection of December 31, 2021, notes…
Perez Company, which expects to start operations on January 1, 2018, will sell digital cameras in shopping malls. Perez has budgeted sales as indicated in the following table. The company expects a 12 percent increase in sales per month for February and March. The ratio of cash sales to sales on account will remain stable from January through March. Required a. Complete the sales budget by filling in the missing amounts. b. Determine the amount of sales revenue Perez will report on its first quarter pro forma income statement. Complete this question by entering your answers in the tabs below. Required A Required B Complete the sales budget by filling in the missing amounts. (Round intermediate calculations and final answers to 2 decimal places.) Sales January February March $ 46,000 116,000 Cash sales Sales on account Total budgeted sales $ 162,000
The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 12,300 13,300 15,300 14,300 The selling price of the company's product is $22 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made, 20% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning balance of accounts receivable, all of which is expected to be collected in the first quarter, is $72,800. The company expects to start the first quarter with 2,460 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to 20% of the next quarter's budgeted sales. The desired ending finished goods inventory for the fourth quarter is 2,660 units.
Orange Company has sales of RM50,000 in March and RM60,000 in April.Forecast sales for May, June, and July are RM70,000, RM80,000, andRM100,000, respectively. The firm has a cash balance of RM5,000 on 1 Mayand wishes to maintain a minimum cash balance of RM5,000.Given the following data, prepare and interpret a cash budget for the months of May, June, and July. • The firm makes 20% of sales for cash, 60% are collected in the nextmonth, and the remaining 20% are collected in the second monthfollowing sale• The firm receives other income of RM2,000 per month• The firm’s actual or expected purchases, all made for cash, areRM50,000, RM70,000, and RM80,000 for the months of May throughJuly, respectively• Rent is RM3,000 per month• Wages and salaries are 10% of the previous month’s sales• Cash dividends of RM3,000 will be paid in June• Payment of principal and interest of RM4,000 is due in June• A cash purchase of equipment costing RM6,000 is scheduled in July• Taxes of RM6,000 are due in…
Fill in the missing cells in the following cash budget. Interpret the values for NCF and the ending cash position. Develop a cash budget for the next two months using the following information: Monthly sales forecasts are $210,000 and $30,000 for the next two months Sales in the current month were $140,000 80 percent of sales are collected in the month of sale, with the remainder collected in the following month Cost of goods sold equal 70 percent o sales The monthly lease payment is $75,000 The cash position at the end of the current month is $70,000 The target cash balance is $40,000
BCAS Ltd is developing a cash budget for April, May and June 2022, and the following information was gathered: Cash Receipts 1 Sales revenue for February and March 2022 are $200,000 and $180,000 respectively. The forecasted sales revenue for April, May and June 2022 are $170,000, $220,000 and $280,000 respectively. Historically, 30% of the firm’s sales are in cash, 60% are collected in the next month, and the remaining 10% are collected in the second month following the sale. 2 Monthly rental income received is $60,000. 3 Interest income of $10,000 will be received in May 2022. Cash Disbursements 4 The expected purchases are $150,000, $110,000 and $190,000 for the months of April, May and June 2022 respectively. The company pays all its purchases in the month of purchase. 5 Monthly salaries paid is $70,000. 6 Commission is paid to its salesman at 2% of current month’s sales. 7 Renovation of all retail outlets amounting to $400,000…
Parliament Company, which expects to start operations on January 1, year 2, will sell digital cameras in shopping malls. Parliament has budgeted sales as indicated in the following table. The company expects a 10 percent increase in sales per month for February and March. The ratio of cash sales to sales on account will remain stable from January through March. Required a. Complete the sales budget by filling in the missing amounts. b. Determine the amount of sales revenue Parliament will report on its first quarter pro forma income statement. Complete this question by entering your answers in the tabs below. Required A Required B Complete the sales budget by filling in the missing amounts. February Sales Cash sales Sales on account Total budgeted sales January $ 50,000 120,000 $ 170,000