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 13 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 45,000 112,000 $ 157,000 $ $ February 0.00 $ March 0.00

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 13 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 45,000 112,000 $ 157,000 $ $ February 0.00 $ March 0.00

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

ABC Company's budgeted sales for June, July, and August are 14,200, 18,200, and 16,200 units respectively. The selling price for each unit is $15. Based on past experience, ABC expects that 40% of a month's sales will be collected in the month of sale, 55% in the following month, and 2% in the second month following the sale. Required: Prepare an analysis of cash receipts from sales for ABC Company for August. Budgeted sales units Unit selling price Budgeted sales revenue August collections: Current month's sales. Prior month's sales. Second prior month's sales. Total collections June July August
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…
A company is preparing its cash budget for the upcoming quarter. The company's sales are expected to be $500,000 in January, $600,000 in February, and $700,000 in March. The company's cost of goods sold is 60% of sales. The company's beginning cash balance is $50,000, and the company desires to maintain a minimum cash balance of $25,000. What is the company's budgeted cost of goods sold for February? $360,000 $540,000 $450,000 $350,000
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
Mitchell Company had the following budgeted sales for the first half of next year: The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled: Assume that the accounts recelvable balance on January 1 was $76,000. Of this amount, $60,000 represented uncollected December sales and $16,000 represented uncollected November sales. Glven these data, the total cash collected during January would be: Multiple Choice $138.000 $100,000 $196,000 $197,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?
Please answer the question What are the estimated cash receipts for March, if 20 percent of sales are cash, 40 percent are credit sales paid in the month after the sale, and 40 percent are credit sales paid 2 months after the sale? Answer it with complete solutions and explanations if needed. Thank you
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