LaMarande Company is preparing a budgeted income statement and cash budget for the year ended December...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
LaMarande Company is preparing a budgeted income statement and cash budget for the year ended December 31, 20X3. Selected information is already shown on the forms. Use the following additional information. All unit amounts are rounded to the nearest 100 units and dollar amounts to the nearest $10.00 a. The unit sales price will remain at $8.00. b. The number of units sold is projected to increase 5%. c. Unit costs in 20X2 were $5.30; unit costs are projected to be $5.80 in 20X3. The cost of inventory on hand January 1, 20X3, is $5.30 per unit. The ending inventory for 20X2 is 25,800 units. d. In each quarter, cash sales are 10% and collections of accounts receivable are 50% of the projected net sales for the current quarter. Collections from the preceding quarter's net sales are 39% of that quarter. Uncollectible accounts are 1% of net sales. e. The balance of cash on hand January 1, 20X3, is $37,000.00. Instructions: 1. Complete the sales budget. 2. Complete the purchases budget. 3. Complete the budgeted income statement. 4. Complete the cash receipts budget. 5. Complete the cash budget. 1. Actual Unit Sales, 20X2 Sales Percentage by Quarter Projected Unit Sales, 20X3 Times Unit Sales Price Net Sales LaMarande Company Sales Budget For Year Ended December 31, 20X3 Annual Budget 160,000 1st 33,900 2nd Quarter 42,700 3rd 38,400 Schedule 1 4th 45,000 2. Unit Sales for Quarter Ending Inventory Required Total Units Needed Less Beginning Inventory Purchases Times Unit Cost Cost of Purchases LaMarande Company Purchases Budget For Year Ended December 31, 20X3 1st 18,000 1st 2nd Quarter 16,100 2nd Quarter 3rd 18,800 3rd Schedule 2 4th 19,200 4th 3. Operating Revenue: Net Sales (Schedule 1) Cost of Merchandise Sold: Beginning Inventory Purchases (Schedule 2) Total Merchandise Available Less Ending Inventory Cost of Merchandise Sold Gross Profit on Sales Operating Expenses: Selling Expenses (Schedule 3) Admin. Expenses (Schedule 4) Total Operating Expenses Income from Operations Other Expenses (Schedule 5) Net Income before Federal Income Tax Federal Income Tax Expense Net Income after Federal Income Tax LaMarande Company Budgeted Income Statement For Year Ended December 31, 20X3 Annual Budget $120,600 202,580 $323,180 6,000 11,200 Annual Budget 1st $26,980 49,140 $76,120 1,500 2,860 1st 2nd $31,600 50,800 Quarter $82,400 1,500 3,120 2nd Quarter 3rd $29,380 49,560 $78,940 1,500 1,730 3rd Schedule 3 4th $32,640 53,080 $85,720 1,500 3,490 4th 4. Cash Receipts from Sales: Prior Year's 4th-Quarter Sales 1st-Quarter Sales ($284,800) 2nd-Quarter Sales ($359,200) 3rd-Quarter Sales ($322,400) 4th-Quarter Sales ($377,600) Total Cash Receipts from Sales Cash Receipts from Other Sources: Note Payable to Bank Total Cash Receipts LaMarande Company Cash Receipts Budget For Year Ended December 31, 20X3 1st $140,400 17,800 2nd Quarter 3rd Schedule 4 4th 5. Cash Balance Beginning Cash Receipts Budget (Schedule A) Cash Available Less Cash Payments Cash Balance-Ending LaMarande Company Cash Budget For Year Ended December 31, 20X3 1st 304,900 2nd Quarter 352,980 3rd 311,580 Schedule 5 4th 359,360 LaMarande Company is preparing a budgeted income statement and cash budget for the year ended December 31, 20X3. Selected information is already shown on the forms. Use the following additional information. All unit amounts are rounded to the nearest 100 units and dollar amounts to the nearest $10.00 a. The unit sales price will remain at $8.00. b. The number of units sold is projected to increase 5%. c. Unit costs in 20X2 were $5.30; unit costs are projected to be $5.80 in 20X3. The cost of inventory on hand January 1, 20X3, is $5.30 per unit. The ending inventory for 20X2 is 25,800 units. d. In each quarter, cash sales are 10% and collections of accounts receivable are 50% of the projected net sales for the current quarter. Collections from the preceding quarter's net sales are 39% of that quarter. Uncollectible accounts are 1% of net sales. e. The balance of cash on hand January 1, 20X3, is $37,000.00. Instructions: 1. Complete the sales budget. 2. Complete the purchases budget. 3. Complete the budgeted income statement. 4. Complete the cash receipts budget. 5. Complete the cash budget. 1. Actual Unit Sales, 20X2 Sales Percentage by Quarter Projected Unit Sales, 20X3 Times Unit Sales Price Net Sales LaMarande Company Sales Budget For Year Ended December 31, 20X3 Annual Budget 160,000 1st 33,900 2nd Quarter 42,700 3rd 38,400 Schedule 1 4th 45,000 2. Unit Sales for Quarter Ending Inventory Required Total Units Needed Less Beginning Inventory Purchases Times Unit Cost Cost of Purchases LaMarande Company Purchases Budget For Year Ended December 31, 20X3 1st 18,000 1st 2nd Quarter 16,100 2nd Quarter 3rd 18,800 3rd Schedule 2 4th 19,200 4th 3. Operating Revenue: Net Sales (Schedule 1) Cost of Merchandise Sold: Beginning Inventory Purchases (Schedule 2) Total Merchandise Available Less Ending Inventory Cost of Merchandise Sold Gross Profit on Sales Operating Expenses: Selling Expenses (Schedule 3) Admin. Expenses (Schedule 4) Total Operating Expenses Income from Operations Other Expenses (Schedule 5) Net Income before Federal Income Tax Federal Income Tax Expense Net Income after Federal Income Tax LaMarande Company Budgeted Income Statement For Year Ended December 31, 20X3 Annual Budget $120,600 202,580 $323,180 6,000 11,200 Annual Budget 1st $26,980 49,140 $76,120 1,500 2,860 1st 2nd $31,600 50,800 Quarter $82,400 1,500 3,120 2nd Quarter 3rd $29,380 49,560 $78,940 1,500 1,730 3rd Schedule 3 4th $32,640 53,080 $85,720 1,500 3,490 4th 4. Cash Receipts from Sales: Prior Year's 4th-Quarter Sales 1st-Quarter Sales ($284,800) 2nd-Quarter Sales ($359,200) 3rd-Quarter Sales ($322,400) 4th-Quarter Sales ($377,600) Total Cash Receipts from Sales Cash Receipts from Other Sources: Note Payable to Bank Total Cash Receipts LaMarande Company Cash Receipts Budget For Year Ended December 31, 20X3 1st $140,400 17,800 2nd Quarter 3rd Schedule 4 4th 5. Cash Balance Beginning Cash Receipts Budget (Schedule A) Cash Available Less Cash Payments Cash Balance-Ending LaMarande Company Cash Budget For Year Ended December 31, 20X3 1st 304,900 2nd Quarter 352,980 3rd 311,580 Schedule 5 4th 359,360
Expert Answer:
Related Book For
Advanced Financial Accounting
ISBN: 978-0078025624
10th edition
Authors: Theodore E. Christensen, David M. Cottrell, Richard E. Baker
Posted Date:
Students also viewed these accounting questions
-
Selected account balances for the year ended December 31 are provided below for Superior Company: Selling and administrative salaries ........................... $110,000 Purchases of raw materials...
-
The statement of cash flows for the year ended December 31, 2013, for Bronco Metals is presented below. Required: Prepare the statement of cash flows assuming that Bronco prepares its financial...
-
The following cash data for the year ended December 31 were adapted from a recent annual report of Alphabet (GOOG), formerly known as Google. The cash balance as of January 1 was $18,347 (in...
-
How is the standard form of a circles equation obtained from its general form?
-
Dearborn Supplies has total sales of $200 million, assets of $100 million, a return on equity of 30 percent, and a net profit margin of 7.5 percent. What is the firms debt ratio?
-
a. Decipher the message YITJP GWJOW FAQTQ XCSMA ETSQU SQAPU (5 SOGKC POTYJ using the Hill cipher with the inverse key (;). calculations and the result. b. Decipher the message MWALO LIAIW WTGBH JNTAK...
-
What are the two categories of data mining and knowledge discovery software?
-
Arantxa Corporation made the following cash purchases of securities during 2008, which is the first year in which Arantxa invested in securities. 1. On January 15, purchased 10,000 shares of Sanchez...
-
5. If you were to connect an ammeter to measure current in the circuit at points A, B, and C how would the readings compare? (Do not connect ammeter yet) Explain the reasoning for your prediction....
-
Thomas was raised with an understanding of the fundamental differences between right and wrong. As an adult, he wasn't making enough money to purchase a new car as quickly as he liked. He found out...
-
Using the graph, estimate the yeast population at T-4 hours. Then estimate the yeast population at T-8 hours. Calculate the the number of new yeast that appeared between hours 4 and 8. This value is...
-
The Speedy Oil Change Company advertised a 15-minute wait for anoil change. A sample of 23 oil changes showed a mean time of 13.5minutes and a standard deviation of 4.3 minutes. At the 5% level...
-
1. If Maria continues charging $150 per month on her card, what would her monthly payment need to be in order to pay off her debt in 24 months? Use the Credit Card payoff Calculator.
-
2. Given the following Macro Model Y = C + I + G 0 C = a + b Y I = k + m Y (i) Solve the system for its endogenous variables by the substitution method ( Y , C , I ) and specify the government...
-
Discuss in the detail the Balance Sheet. What is shown on the Balance Sheet? Why is the Balance Sheet important to a hospitality firm?
-
Examine the balance sheet of commercial banks in the following table. $ Billion % Total Assets Real assets Liabilities Equipment and premises $ 173.7 1.1% Deposits Other real estate 38.9 0.3 Total...
-
(a) Define the following in terms of gain or loss of hydrogen with one example each : (i) oxidation (ii) reduction (b) When a magnesium ribbon is heated, it burns in air to form magnesium oxide....
-
Solve the relation Exz:Solve therelation ne %3D
-
The company that employs you is a U.S. publicly traded corporation that manufactures chemicals. You are in the external financial reporting department, and your position requires that you keep...
-
Teresa Corporation acquired all the voting shares of Sally Enterprises on January 1, 20X4. Balance sheet amounts for the companies on the date of acquisition were as follows: Sally Enterprises...
-
Refer to the data in Exercise E12-5. Required a. Prepare a proof of the translation adjustment computed in Exercise E12-5. b. Where is the translation adjustment reported on Popular Creeks...
-
An analysis of the accounts of Beautiful Bottles Pty Ltd reveals the following manufacturing cost data for the month ended 30 June 2019. Required (a) Prepare the cost of goods manufactured schedule...
-
The following accounts and amounts (balances are normal balances) were taken from the records of Prider Manufacturers Ltd at 30 June 2019. Required (a) Prepare a cost of goods manufactured statement...
-
The following data were taken from the records of Manik Manufacturing Ltd for the year ended 30 June 2019. Required (a) Prepare the cost of goods manufactured schedule for the year ended 30 June...
Study smarter with the SolutionInn App