Frenchies is a medium-sized regional bakery that specializes in providing orders to grocery and convenience stores....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Frenchies is a medium-sized regional bakery that specializes in providing orders to grocery and convenience stores. Because of the popularity of its brand, it has also opened a small café for walk-in business. In order to maintain its high quality standard, Frenchies produces only three products: breakfast muffins, fresh bread, and chocolate chip cookies. Although business has been good in the past few years, a lucky contact with a large chain has recently allowed it to expand its brand out of the local region. Growth has been high since the new contract went into effect. In 2020, Frenchies sold 45,000 one-dozen packages of muffins for $5.50 each, 65,000 one-dozen packages of cookies for $4.75 each, and 85,000 one-dozen loaves of bread for $5.25 each. They will raise prices to $6.00 for muffins, $5.25 for cookies, and $5.75 for bread for 2021. Sales will drop some in the first quarter of 2021. They always drop off a bit after the holidays anyway, but with the increase in sales prices, a 20 percent drop from the fourth quarter of 2020 results is forecasted. Sales will grow steadily at about 5 percent a quarter with these new prices during 2021. Fourth-quarter sales will be high because of the holidays let's say 20 percent, instead of 5 percent, from the third to the fourth quarter. The first quarter of the 2022 will continue the 5 percent growth as though the holiday jump didn't occur. Frenchies gives their business customers a lot of leeway in paying. They collect 30 percent of the credit sales within the current quarter, 45 percent in the following quarter, and 25 percent in the quarter after that. Total sales were $802,000 in third quarter and $1,002,500 in the fourth quarter of 2020. They will be still collecting quite a bit of that money in 2021 based on our collection breakdown. Frenchies cookies and bread would dry out if they kept them too long so they normally keep only about two days' worth of inventory on hand to avoid shipping issues or problems with the café based on a 90-day quarter. Frenchies' raw materials are needed for the next quarter, so they keep 15 percent of the next quarter's raw materials on hand at all times. Using this information, complete the three tabs in the worksheet. Just fill in the forecasted data in the blue boxes and copy the formulas to complete the sheets! Sales 04 5883 88 Q1 Q2 03 04 01 Q2 Estimated % drop Last Year Currect Your Next Year Sales Pricettem: Collection Information: Credit Policy Cash Sales Credit Sales Muffins Collection in Current Quarter Collection in Following Quarter Collection in 3rd Quarter Collections from Last Year's Sales: Quarter 03 04 45,000 Manufacturing Information: Sold 0 0 0 0 $6.00 Ending Inventory Goal Raw Materials Goal Cookies Case Data 05.000 $5.25 Prior Year Received Estimated Growth 10% 90% 30% 45% 25% 50 50 Bread 85,000 01 $5.75 Current Year $0 888 50 Sales Numbers Trasposed for Copying Muffins 50 50 $0 Q1 Cookies Bread Q1 Estimated Additional Holiday Increase Q1 Payments in Current Year Q2 03 0 10% Collection Schedule Transposed for Copying 90% 01 02 03 30% 37,0% 45% 25% 40.5% 2021 $0 $0 $0 02 2021 02 2021 0 22.5% 04 50 $0 $0 03 03 03 0 0 0 Signifies original case assumptions. 04 04 04 0 0 0 01 Q1 Q1 2022 2022 0 02 02 2022 02 0 0 0 0 Muffins Budgeted Sales Selling price per dozen Cookies Total Sales Revenue from Muffins Budgeted Sales Selling price per dozen Bread Total Sales Revenue for Cookies Budgeted Sales Selling price per loaf Total Sales Revenue for Bread Total Sales Revenue Collections from last year Q1 Q2 Q3 Q4 Total Cash Collections Sales Budget Q1 $6.00 $0 • po 15 $5.25 Q1 0 $0 0 $5.75 $0 888888 $0 0 $0 $0 $0 Q2 Quarter 0 $6.00 $0 Schedule of Cash Collections Quarter $5.25 $0 0 Q2 0 $5.75 $0 $0 $0 $0 $0 $0 $0 $0 Q3- °89 0 $6.00 Q3 $0 0 $5.25 $0 0 $5.75 $0 $0 $0 $0 $0 $0 $0 $0 Q4 $6.00 $0 0 +1 Q4 0 $5.25 $0 0 $5.75 $0 $0 $0 $0 $0 $0 $0 $0 Total 2021 0 $6.00 $0 0 $5.25 $0 Total 2021 0 $5.75 $0 $0 $0 $0 $0 $0 $0 $0 Q1 2022 0 $6.00 $0 0 $5.25 $0 Accts. Rec. 12/31/21 0 $5.75 $0 $0 + $0 88888 $0 $0 $0 $0 Q2 0 $6.00 $0 0 $5.25 $0 0 $5.75 $0 $0 Muffins Budgeted Sales Desired Ending Inventory Total Units Needed Less: Beginning Inventory Cookies Required Muffin Production Budgeted Sales Desired Ending Inventory Total Units Needed Less: Beginning Inventory Bread Required Cookie Production Budgeted Sales Desired Ending Inventory Total Units Needed Less: Beginning Inventory Required Bread Production G Production Budget Q1 151 ooooo 0 0 0 0 0 loooo 0 0 0 0 0 ooooo 0 0 0 Q2 Quarter 00000 oooo 0 ooooo 0 0 0 0 0 Q3 00000 ooooo 0 ooooo 0 0 0 0 -Q4 0 ooooo 0 0 ooooo ooooo Total 2021 ooooo 0 0 0 0 0 ooooo 0 ooooo 0 K L Q1 OUZE J TIDE 2022 00000 ooooo ooooo M Q2 0 0 0 Frenchies is a medium-sized regional bakery that specializes in providing orders to grocery and convenience stores. Because of the popularity of its brand, it has also opened a small café for walk-in business. In order to maintain its high quality standard, Frenchies produces only three products: breakfast muffins, fresh bread, and chocolate chip cookies. Although business has been good in the past few years, a lucky contact with a large chain has recently allowed it to expand its brand out of the local region. Growth has been high since the new contract went into effect. In 2020, Frenchies sold 45,000 one-dozen packages of muffins for $5.50 each, 65,000 one-dozen packages of cookies for $4.75 each, and 85,000 one-dozen loaves of bread for $5.25 each. They will raise prices to $6.00 for muffins, $5.25 for cookies, and $5.75 for bread for 2021. Sales will drop some in the first quarter of 2021. They always drop off a bit after the holidays anyway, but with the increase in sales prices, a 20 percent drop from the fourth quarter of 2020 results is forecasted. Sales will grow steadily at about 5 percent a quarter with these new prices during 2021. Fourth-quarter sales will be high because of the holidays let's say 20 percent, instead of 5 percent, from the third to the fourth quarter. The first quarter of the 2022 will continue the 5 percent growth as though the holiday jump didn't occur. Frenchies gives their business customers a lot of leeway in paying. They collect 30 percent of the credit sales within the current quarter, 45 percent in the following quarter, and 25 percent in the quarter after that. Total sales were $802,000 in third quarter and $1,002,500 in the fourth quarter of 2020. They will be still collecting quite a bit of that money in 2021 based on our collection breakdown. Frenchies cookies and bread would dry out if they kept them too long so they normally keep only about two days' worth of inventory on hand to avoid shipping issues or problems with the café based on a 90-day quarter. Frenchies' raw materials are needed for the next quarter, so they keep 15 percent of the next quarter's raw materials on hand at all times. Using this information, complete the three tabs in the worksheet. Just fill in the forecasted data in the blue boxes and copy the formulas to complete the sheets! Sales 04 5883 88 Q1 Q2 03 04 01 Q2 Estimated % drop Last Year Currect Your Next Year Sales Pricettem: Collection Information: Credit Policy Cash Sales Credit Sales Muffins Collection in Current Quarter Collection in Following Quarter Collection in 3rd Quarter Collections from Last Year's Sales: Quarter 03 04 45,000 Manufacturing Information: Sold 0 0 0 0 $6.00 Ending Inventory Goal Raw Materials Goal Cookies Case Data 05.000 $5.25 Prior Year Received Estimated Growth 10% 90% 30% 45% 25% 50 50 Bread 85,000 01 $5.75 Current Year $0 888 50 Sales Numbers Trasposed for Copying Muffins 50 50 $0 Q1 Cookies Bread Q1 Estimated Additional Holiday Increase Q1 Payments in Current Year Q2 03 0 10% Collection Schedule Transposed for Copying 90% 01 02 03 30% 37,0% 45% 25% 40.5% 2021 $0 $0 $0 02 2021 02 2021 0 22.5% 04 50 $0 $0 03 03 03 0 0 0 Signifies original case assumptions. 04 04 04 0 0 0 01 Q1 Q1 2022 2022 0 02 02 2022 02 0 0 0 0 Muffins Budgeted Sales Selling price per dozen Cookies Total Sales Revenue from Muffins Budgeted Sales Selling price per dozen Bread Total Sales Revenue for Cookies Budgeted Sales Selling price per loaf Total Sales Revenue for Bread Total Sales Revenue Collections from last year Q1 Q2 Q3 Q4 Total Cash Collections Sales Budget Q1 $6.00 $0 • po 15 $5.25 Q1 0 $0 0 $5.75 $0 888888 $0 0 $0 $0 $0 Q2 Quarter 0 $6.00 $0 Schedule of Cash Collections Quarter $5.25 $0 0 Q2 0 $5.75 $0 $0 $0 $0 $0 $0 $0 $0 Q3- °89 0 $6.00 Q3 $0 0 $5.25 $0 0 $5.75 $0 $0 $0 $0 $0 $0 $0 $0 Q4 $6.00 $0 0 +1 Q4 0 $5.25 $0 0 $5.75 $0 $0 $0 $0 $0 $0 $0 $0 Total 2021 0 $6.00 $0 0 $5.25 $0 Total 2021 0 $5.75 $0 $0 $0 $0 $0 $0 $0 $0 Q1 2022 0 $6.00 $0 0 $5.25 $0 Accts. Rec. 12/31/21 0 $5.75 $0 $0 + $0 88888 $0 $0 $0 $0 Q2 0 $6.00 $0 0 $5.25 $0 0 $5.75 $0 $0 Muffins Budgeted Sales Desired Ending Inventory Total Units Needed Less: Beginning Inventory Cookies Required Muffin Production Budgeted Sales Desired Ending Inventory Total Units Needed Less: Beginning Inventory Bread Required Cookie Production Budgeted Sales Desired Ending Inventory Total Units Needed Less: Beginning Inventory Required Bread Production G Production Budget Q1 151 ooooo 0 0 0 0 0 loooo 0 0 0 0 0 ooooo 0 0 0 Q2 Quarter 00000 oooo 0 ooooo 0 0 0 0 0 Q3 00000 ooooo 0 ooooo 0 0 0 0 -Q4 0 ooooo 0 0 ooooo ooooo Total 2021 ooooo 0 0 0 0 0 ooooo 0 ooooo 0 K L Q1 OUZE J TIDE 2022 00000 ooooo ooooo M Q2 0 0 0
Expert Answer:
Answer rating: 100% (QA)
Answer Table 3 Production Budget Quarter Total 2016 Q1 Q2 Q3 Q4 2015 Q1 Q2 Muffins Budgeted Sal... View the full answer
Related Book For
Cost Management Measuring, Monitoring and Motivating Performance
ISBN: 978-1119185697
3rd Canadian edition
Authors: Leslie G. Eldenburg, Susan K. Wolcott, Liang Hsuan Chen, Gail Cook
Posted Date:
Students also viewed these accounting questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
1. Based on the information provided in the case below, what is the key strategic goal for Tim Hortons as of August 2014? It would be a year of dramatic change for Tim Hortons Inc. On August 26,...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Solve the right triangles with the given parts or state that there is not enough information to solve. Round off results according to Table 4.1. Refer to Fig. 4.37. B = 32.1, c = 238 Data from Table...
-
What is a voucher?
-
The weight of equity in Strattons capital structure as a result of the acquisition of Midwest assuming Lees two assumptions is closest to: A. 29%. B. 71%. C. 81%. Elaine Lee is an analyst at an...
-
The pressure limit in a Otto cycle are 1 bar and 20 bar. The compression ratio is 5. Calculate (a) thermal efficiency, and (b) mean effective pressure. Assume \(\gamma=1.4\) for air.
-
Callahan (2009) conducted a study to evaluate the effectiveness of physical exercise programs for individuals with chronic arthritis. Participants with doctor-diagnosed arthritis either received a...
-
Fanshawe college Course Code : MGMT 6147 : Trends in Management & Leadership Module & Case: #10: Motivated reasoning, leadership, and team performance. 1) Please provide a brief summary of the case....
-
Go through the transaction list (Document1) and identify which cycle each transaction belongs to. A transaction will belong to only one cycle; either the Sale to Cash Receipt (S/CR) Cycle, Purchases...
-
The following cash-flow pattern has two IRRs. Use Excel to draw a graph of the NPV of these cash flows as a function of the discount rate. Then use the IRR function to identify the two IRRs. Would...
-
You are on an airplane flying at a steady \(250 \mathrm{~m} / \mathrm{s}\) at cruising altitude. At noon the pilot announces that you are passing over the center of London and exactly \(6.0...
-
Consider a searchlight on the ground that casts a spot on a cloud \(1000 \mathrm{~m}\) overhead. If the searchlight is rotated rapidly-say, \(30^{\circ}\) in \(1 \mu \mathrm{s}\)-how fast does the...
-
To determine what effect a spring's mass has on simple harmonic motion, consider a spring of mass \(m\) and relaxed length \(\ell_{\text {spring }}\). The spring is oriented horizontally, and one end...
-
A cosmic ray traveling at \(0.400 c_{0}\) relative to Earth passes observer A (event 1) and then a short time interval later passes observer B (event 2). The observers are at rest, \(8.00...
-
Two events occur at different locations on Farth and are simultaneous in the reference frame of an observer standing on Earth halfway between the events. Are these events simultaneous in any other...
-
Examine the code below, then do the following:. 1. Test it and determine whether it works as expected. 2. Write the loop with a boolean condition (not simply true.) 3. Write the loop and without...
-
The following data are supplied for the common stocks of Nikola Corporation, Tesla, Inc. and General Motors: Nikola Corp (NKLA) Tesla Inc. (TSLA) Close Price ($) Close Price ($) 67.53 30.00 40.81...
-
Anchor Manufacturing has forecasted sales of 5,000 units of its product at $75 each for the next month. Beginning inventory consists of 800 grams of direct materials and 300 units of finished goods....
-
1. In process costing, if the units in beginning inventory are at less than 100% completion, what will be the cost of production per equivalent unit for the period under weighted average costing...
-
A business uses the step-down method to allocate service department costs to the manufacturing departments. There are two service departments and two manufacturing departments, as shown here: Plant...
-
At 30 June 2024, the accountant for Woodbine Construction, Mary Ellam, is preparing the financial statements for the year ended on that date. To calculate the annual leave payable, the accountant had...
-
How would each of the following liabilities be classified (current, non-current, or both) at the end of the financial year? Unearned revenue Accrued expenses Provision for warranty repair costs...
-
The following were among transactions of Everluck Enterprises Ltd during the financial years ending 30 June 2023 and 30 June 2024. Required Record in general journal form all the above transactions,...
Study smarter with the SolutionInn App