Tracy is preparing her budget for next year and needs your assistance. Now that she has...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Tracy is preparing her budget for next year and needs your assistance. Now that she has a better idea of what to expect now that she is in business full time, we want to begin having some of her ingredients in stock to avoid not being able to get the ingredients on time. She is ready to prepare her budget for the first four months of 2021. She believes she will sell the following number of cupcakes each month: Month # of cupcakes All cupcakes are sold each month and she has no beginning or ending cupcake inventory. January February March April 7650 7150 - 8150 7250 Tracy would like for you to create a cash collections budget if she sells each cupcake for $3.05 each. She anticipates that 75% of her sales will be cash sales and the remaining 25% will be on account. Of the 25% on account, she believes she will receive 65% the month of sales and 35% the second month. The beginning accounts receivable is $1,950. Lastly, she would like for you to create a direct materials budget. She would like to keep 10% of next month's ingredient inventory on hand at the end of each month. Each cupcake uses 5.5 oz. of material and the cost per ounce is $0.09. Her inventory on January 1 is 3,650 oz. and her presumed ending inventory on April 30h is 3,200 oz. She pays for all materials in the month of purchase. Please complete a Direct Materials Budget and an Expected Cash Disbursement for Materials. Prepare a one page paper where you give Tracy the requested budgets and explain how you determined the amounts. Remember: Write the paper to Tracv as a business document. Tracy is preparing her budget for next year and needs your assistance. Now that she has a better idea of what to expect now that she is in business full time, we want to begin having some of her ingredients in stock to avoid not being able to get the ingredients on time. She is ready to prepare her budget for the first four months of 2021. She believes she will sell the following number of cupcakes each month: Month # of cupcakes All cupcakes are sold each month and she has no beginning or ending cupcake inventory. January February March April 7650 7150 - 8150 7250 Tracy would like for you to create a cash collections budget if she sells each cupcake for $3.05 each. She anticipates that 75% of her sales will be cash sales and the remaining 25% will be on account. Of the 25% on account, she believes she will receive 65% the month of sales and 35% the second month. The beginning accounts receivable is $1,950. Lastly, she would like for you to create a direct materials budget. She would like to keep 10% of next month's ingredient inventory on hand at the end of each month. Each cupcake uses 5.5 oz. of material and the cost per ounce is $0.09. Her inventory on January 1 is 3,650 oz. and her presumed ending inventory on April 30h is 3,200 oz. She pays for all materials in the month of purchase. Please complete a Direct Materials Budget and an Expected Cash Disbursement for Materials. Prepare a one page paper where you give Tracy the requested budgets and explain how you determined the amounts. Remember: Write the paper to Tracv as a business document.
Expert Answer:
Answer rating: 100% (QA)
Dear Tracy Based on the information you provided for the first 4 months of 2021 I have worked out and presented here both Cash Collections Budget and ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Delia, Inc. is preparing a budget for next year and requires a breakdown of the cost of steam used in its factory into fixed and variable components. The following data on the cost of steam used and...
-
The Global Growth Corporation is planning for next year and wants you to help them prepare a Pro Forma Balance Sheet for 2015.Their current Balance Sheet is shown below along with some pre-determined...
-
The Global Growth Corporation is planning for next year and wants you to help them prepare a Pro Forma Balance Sheet for 2011. Their current Balance Sheet is shown below along with some...
-
Consider a cube that has 5cm length sides. What is the surface area to volume ratio of this cube? Report your answer in cm/cm Report your answer to one decimal place. QUESTION 12 Consider a cube that...
-
Describe the assumptions of and name and describe the four styles of leadership from Robert House's path goal theory.
-
Find the arithmetic mean of each list of numbers in Problems 1720. 5, 4, 2, 1, and 6
-
The manager of Quality Fabricators Ltd has just reviewed the income statement for the previous quarter and is concerned by the profit earned. Her main concern is the significant difference between...
-
1. Use descriptive statistics to summarize the data from the two studies. What are your preliminary observations about the depression scores? 2. Use analysis of variance on both data sets. State the...
-
Windsor's Drillers erects and places into service an off-shore oil platform on January 1, 2025, at a cost of $9,360,000. Windsor estimates it will cost $1,088,000 to dismantle and remove the platform...
-
Interest During Construction Matrix Inc. borrowed $1,100,000 at 8% to finance the construction of a new building for its own use. Construction began on January 1, 2019, and was completed on October...
-
Samsung Ltd. are the manufacturers of Television. The following are the details of a Product during the year 2022. Ordering Cost Rs.50 per order Inventory carrying cost 10% per annum Cost of Product...
-
ELR Construction purchased a truck 6 years ago at a cost of $68800. Because the old truck required an overhaul of $5200 last year, and repairs of $2000 are needed in the current year, the company is...
-
Use the formula: P = M(1-DT) where P is net proceeds of a note that has been discounted; M is maturity value, D is the discount rate, and T is time of the note to solve the following question:A $1000...
-
Use the formula: P = M(1-DT) where P is net proceeds of a note that has been discounted; M is maturity value, D is the discount rate, and T is time of the note to solve the following question:A...
-
1). With reference to the economy of country X the level of I is $755 million, G is $1100 million and T is $100 million. Assume that this is a closed economy with an MPC of 0.85 and autonomous...
-
A permanent cut in government spending (with no change in taxation) can result in a new medium-run equilibrium with higher unemployment and lower real wages in an open economy with an...
-
This is a partial adjusted trial balance of Sandhill Co.. SANDHILL CO. Adjusted Trial Balance January 31, 2022 Debit Credit Supplies $750 Prepaid Insurance 1,530 Salaries and Wages Payable $1,050...
-
Evaluate the line integral, where C is the given curve. C x 2 dx + y 2 dy, C consists of the arc of the circle x 2 + y 2 = 4 from (2, 0) to (0, 2) followed by the line segment from (0, 2) to (4, 3)
-
Given the information below, estimate the nominal rate with the approximation nominal interest rate equation and the true nominal interest rate equation. True Nominal Approximate Rate Real Rate...
-
Complete the balancesheet Partial Income Statement Year Ending 2011 Sales Revenue COGS Fixed Costs SG&A Expenses Depreciation S350,000 $140,000 S43,000 S 28,000 S46,000 Partial Balance Sheet...
-
Bruce Wayne is going public with his new business. Berkman Investment Bank will be his banker and is doing a best-efforts sale with a 4% commission fee. Wayne has been authorized 5,000,000 shares for...
-
A company expects to receive which of the following benefits when it uses its budgeting process? a. The planning required to develop the budget helps managers foresee and avoid potential problems...
-
The following budgets are all financial budgets except for the a. combined cash budget. b. budgeted balance sheet. c. budgeted income statement. d. capital expenditures budget.
-
The income statement is part of which element of a companys comprehensive budget? a. The operating budgets b. The capital expenditures budget c. The financial budget d. The cash budget
Study smarter with the SolutionInn App