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

Orange Company has sales of $50,000 in March and $60,000 in April. Forecast sales for May, June, and July are $70,000, $80,000, and $100,000, respectively. The firm has a cash balance of $5,000 on 1 May and wishes to maintain a minimum cash balance of $5,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 next month, and the remaining 20% are collected in the second month following sale • The firm recelves other income of $2,000 per month • The firm's actual or expected purchases, all made for cash, are $50,000, $70,000, and $80,000 for the months of May through July, respectively • Rent is $3,000 per month • Wages and salaries are 10% of the previous month's sales • Cash dividends of $3,000 will be paid in June • Payment of principal and interest of $4,000 is due in June • A cash purchase of equipment costing $6,000 is scheduled in July • Taxes of $6,000 are due in…
Given the following information, complete the cash budget: Collections occur one month after the sale. January’s credit sales were $90,000. The firm has a certificate of deposit for $50,000 that matures in April. Salaries are $150,000 a month. The monthly mortgage payment is $20,000. Monthly depreciation is $10,000. Property tax of $35,000 is due in February. Round your answers to the nearest dollar. Enter the disbursements values as positive values. Use a minus sign to enter shortage of cash, negative beginning and ending cash values, if any. Do not leave any cells blank. If the answer is zero, enter "0". February March April Sales $ 170,000 $ 200,000 $ 230,000 Cash sales $ 35,000 $ 20,000 $ 70,000 Collections $ $ $ Other receipts $ $ $ Total cash receipts $ $ $ Salaries $ $ $ Mortgage $ $ $ Other disbursements $ $ $ Total cash disbursements $ $ $ Net…
Prepare a budgeted income statement for July. Please present your solution in a good form and income statement in good form.
I Rooney Company, which expects to start operations on January 1, year 2, will sell digital cameras in shopping malls. Rooney has budgeted sales as indicated in the following table. The company expects a 15 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 Rooney will report on its first quarter pro forma income statement. Complete this question by entering your answers in the tabs below. Required Required B Complete the sales budget by filling in the missing amounts. (Do not round intermediate calculations. Round final answers to two decimal places.) March Sales Cash sales Sales on account Total budgeted sales January February $45,000 115,000 160,000
Nana Kay company must maintain a minimum cash balance of ghc 25000. At the beginning June, the company's cash balance was ghc 17000. Budgeted cash receipts for June are ghc 150000 and budgeted cash disbursement are ghc 201000. Budgeted net income for July totals ghc 11,000. How much will Nana Kay company need to borrow by the end of June?
Bright Minds Toy Company prepared the following sales budget for the second quarter. Projected sales for each of the first three months of operations are as follows: Sales Budget Cash Sales April 130,000 470,000 Sales on Account 600,000 Multiple Choice Bright Minds expects to collect 70% of the sales on account in the month of sale, 20% in the month following the sale, and the remainder in the second month following the sale. What is the ending accounts receivable balance that would be reported on the pro forma balance sheet prepared as of June 30? O O O $202,700 $149,500 $344.000 May 83,000 512,000 595,000 $106,400 June 155,000 505,000 660,000
B. Mahmoud Repair Company is preparing its budget for the first quarter of 2021. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected. Clients usually pay 60% of their fee in the month that service is provided, 30% the month after, and 10% the second month after receiving service. Actual service revenue for 2016 and expected service revenues for 2021 are: November 2020, $120,000; December 2020, $110,000; January 2021, $140,000; February 2021, $160,000; March 2021, $170,000. Purchases on landscaping supplies (direct materials) are paid 40% in the month of purchase and 60% the following month. Actual purchases for 2020 and expected purchases for 2021 are: December 2020, $21,000; January 2021, $20,000; February 2021, $22,000; March 2021, $27,000. Instructions (a) Prepare the following schedules for each month in the first quarter of 2021 and for the quarter in total: (1)…
A company's sales for the nine months to 30 September are $2.5m. The sales forecast for the next three months is $500,000 in total. The company's budgeted sales for the year are $3.4m The company's CEO has a meeting with the sales manager to discuss plans to close the gap between the forecast and the original budgeted sales for the next quarter. What is this process an example of? Feedback control An activity-based budget A rolling budget Feed-forward control
Develop a cash budget for the next three months using the information provided below. Monthly sales forecasts are $150,000, $180,000, and $60,000 (June, July, August) The current month's sales are $120,000 (May) Cost of goods sold equals 65% of sales Lease payment= 22,000 per month The company is required to pay an installment of $120,000 for a note (debt) The cash position at the end of the current month is $80,000 The target cash balance is $50,000 Assume that 60% of sales are collected in the month sold and the remaining collected in the following month.
Getty Company expects sales for the first three months of next year to be $185,000, $235,000 and $310,000, respectively. Getty expects 30 percent of its sales to be cash and the remainder to be credit sales. The credit sales will be collected as follows: 10 percent in the month of the sale and 90 percent in the following month. Compute a schedule of Getty's cash receipts for the months of February and March. February March Budgeted cash receipts $ 250,000
XYZ company is preparing its cash budget for the first quarter of the year. It has $10,000 in cash at the beginning of the period. Cash collections from customers for the quarter are budgeted at $28,000. Cash payment during the quarter for inventory purchases are budgeted at $25,000. The desired cash balance at the end of the quarter is $9,000. Other operating expenses for the quarter are budgeted at $20,000, which includes $3,000 depreciation. Cash expenses are paid in the month incurred. How much borrowing will the company need during the quarter?Select one:a. $13,000b. $19,000c. None of the given answersd. $5,000e. $16,000
Munoz Company is a retail company that specializes in selling outdoor camping equipment. The company is considering opening a new store on October 1, year 1. The company president formed a planning committee to prepare a master budget for the first three months of operation. As budget coordinator, you have been assigned the following tasks. Required a. October sales are estimated to be $340,000, of which 40 percent will be cash and 60 percent will be credit. The company expects sales to increase at the rate of 20 percent per month. Prepare a sales budget. b. The company expects to collect 100 percent of the accounts receivable generated by credit sales in the month following the sale. Prepare a schedule of cash receipts. c. The cost of goods sold is 70 percent of sales. The company desires to maintain a minimum ending inventory equal to 20 percent of the next month's cost of goods sold. However, ending inventory of December is expected to be $12,900. Assume that all purchases are made…