Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Fill out all entries within the Excel tables. Can use an online example from Cliffnotes as an example if needed. Hitchen's Widget store Part 1

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Fill out all entries within the Excel tables. Can use an online example from Cliffnotes as an example if needed.

Hitchen's Widget store Part 1 The following information was provided by Hitchen's widget store for July 31, 202X. They make two products: R2D2 \& C3P0. Both items use 2 of the 3 listed materials: Nada, Yada, and Bozo. Presented below is monthly sales data for the two balls Direct materials - R2D2 uses Nada and C3P0 uses Yada for production. Both products require a Bozo. Costs are $4.22 per foot of Nada Costs are $2.75 per foot of Yada Bozo's cost $7.85 each [ Factor Overhead is broken into variable and fixed costs. Variable costs are estimated by D.L hour of Process \#1. Fixed Costs are divided based on percent of Process \#1 hours. Other Selling and Admin Exnenses not listed above Instructions: Using the attached template fill-in sheet, complete all income statement budgets. Show all work for each budget 1. Sales budget - Determine total sales for each item and the combined total. 2. Production budget - Determine total units to be produced for each item and in total 3. Direct Materials budget - Determine total feet and total cost of each material and in total. 4. Direct Labor budget - Determine total hours and wage cost for each process and in total. 5. Factory O.H. budget - Determine the total variable cost, total fixed cost and manufacturing rate/hour using the cost driver. 6. Determine the Cost of Goods Sold for each item and in total. 7. Prepare the budgeted income statement for July 31,202X Hitchen's Widget store Part 2 Using Hitchen's info from the income statement budgets (part 1), the remaining account info is presented to prepare the components of the balance sheet budgets. Assume the same budget is expected for the next three months (July, Aug, Sept). 1. Opening July 1 cash balance is $578,879. 2. A/R beginning balance of $2,133,435 was 66% collected in July and the remaining in August. 3. Sales: 30% collected in month of sale, 50% the following month, and 20% in the third month. 4. A/P opening balance of $297,454 was paid 70% this month and 30% next month. 5. Direct Materials are paid 30% during month of purchase, 50% the following month, and 20% the third month. 6. W/P had an opening balance of $222,786 and paid off this month 7. Direct Labor is paid 73% this month and the remaining in the following month. 8. Factory Overhead \& Selling/Admin is paid 100% this month (excluding Depreciation) 9. Dividends are expected to be paid of $179,223,$240,000, and $260,000 in the three months respectively 10. Plans are in place to purchase a piece of equipment for $143,567 in month 1 (10\% paid this month, 40% paid in month 2 and the remaining 50% in month 3 ). a. Retired Asset expected to sell for $11,232 and collected 100% in the second month. 11. 100% of income tax is paid each month 12. Beginning balances: a. Equipment =2,164,000 b. Accum. Dep. Equipment =1,256,000 c. Common Stock =$2,500,000 d. Retained Earnings =$1,114,081 Prepare these following budgets for month one, two and three. 1. Schedule of cash collections from customers 2. Schedule of cash payments for D.M. 3. Schedule of cash payments for D.L. 4. Cash Budget 5. Budgeted balance sheet (as of month 1)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial and Managerial Accounting

Authors: Jonathan E. Duchac, James M. Reeve, Carl S. Warren

11th Edition

9780538480901, 9781111525774, 538480890, 538480904, 1111525773, 978-0538480895

More Books

Students also viewed these Accounting questions

Question

=+ b. How would the change you describe in part

Answered: 1 week ago