BK2U is a mobile bike service that services and repairs bikes at customers' homes. It is...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
BK2U is a mobile bike service that services and repairs bikes at customers' homes. It is geared to bicyclists who have invested in expensive bikes and are willing to pay for the convenience of a mobile service. The company is planning to launch the product in Toronto and the surrounding Greater Toronto suburbs. a) List at least five data points you would use to create a top-down forecast (you do not need to do any calculations - focus instead on the process and logic). b) Specify what constraints and data points you would use to create a bottom-up forecast. Jana and Cindy are planning to launch UP-PACK, a business that upcycles disposable masks into high quality packaging material. They think it can be a viable business but they need your advice; they want to make sure they aren't taking too big of a risk. Use the information below to create a 6 month cash budget and calculate the sales figure they need to break-even. Based on their research of the industry, they plan to provide credit terms to their customers of 45% payment during the month of sale and 55% payment in the month following sale. Manufacturing supply costs are relatively low since they can get free used disposable masks from health care facilities but there are costs incurred to clean and upcycle the masks. They project their costs of goods sold (COGS) to be 22% of each month's sales. They anticipate having to pay 60% of these costs in the month of purchase and 40% in the month following purchase. Fortunately, Jana's brother has a large empty garage that they can operate in for the first year which saves them from renting space. They are going to contribute to his utility costs as listed in the chart below. Because they are selling to businesses, their marketing budget is largely allocated to personal selling (reflected in payroll costs). Jana and Cindy have $5,500 set aside as their beginning cash balance. Going forward, they do not want their cash balance to go below $3,000. Because they have strong personal credit histories and other sources of household income from their respective partners, they have been approved for a bank line of credit at a rate of 6%. If they need to use this line of credit, they will pay interest in the month following borrowing. Once they have a cash surplus, they will pay down as much of the outstanding line of credit as possible. Round all amounts up to the nearest dollar when preparing the cash budget. Once you complete the cash budget and break-even, provide advice to Jana and Cindy about how to interpret and make decisions with the resulting numbers. Sales Payroll Utilities Insurance Website Business License Equipment Lease Startup Costs UP-PACK - Combined Question Quiz Question 1 MAR JAN 12000 8400 500 375 125 300 2200 3000 FEB 12000 18,000 8400 8400 500 375 125 500 375 125 2200 2200 APR 18,000 8400 500 375 125 2200 MAY 20,000 8400 500 375 125 2200 JUNE 26,000 8400 500 375 125 2200 Question 3 Selena would like to start a new venture after she finishes school. She projects that her fixed costs will be $68092. She expects that she can sell her product for $16 and that her variable costs per unit will be $8. She knows she has done her research but she is still worried about the risk involved with this new venture. How many units would she have to sell to break-even? Question 4 Jerry and Ben would like to open a new business next year. They have worked hard on their cost projections and believe they can start with fixed costs of $60,000. Their customer research indicates that they can sell their product for $12.00 and variable costs are expected to be $3.50 per unit. They know they have done plenty of research but are still nervous about the risk involved with this new venture. How many units would Jerry and Ben have to sell to break-even? Question 5 Sheldon is considering opening a hockey clinic as a side business but is worried about whether he can manage the risk. He anticipates fixed costs of $140,000, sales of $400,000 and costs of goods sold of $80,000. What sales volume would Sheldon need to break-even? BK2U is a mobile bike service that services and repairs bikes at customers' homes. It is geared to bicyclists who have invested in expensive bikes and are willing to pay for the convenience of a mobile service. The company is planning to launch the product in Toronto and the surrounding Greater Toronto suburbs. a) List at least five data points you would use to create a top-down forecast (you do not need to do any calculations - focus instead on the process and logic). b) Specify what constraints and data points you would use to create a bottom-up forecast. Jana and Cindy are planning to launch UP-PACK, a business that upcycles disposable masks into high quality packaging material. They think it can be a viable business but they need your advice; they want to make sure they aren't taking too big of a risk. Use the information below to create a 6 month cash budget and calculate the sales figure they need to break-even. Based on their research of the industry, they plan to provide credit terms to their customers of 45% payment during the month of sale and 55% payment in the month following sale. Manufacturing supply costs are relatively low since they can get free used disposable masks from health care facilities but there are costs incurred to clean and upcycle the masks. They project their costs of goods sold (COGS) to be 22% of each month's sales. They anticipate having to pay 60% of these costs in the month of purchase and 40% in the month following purchase. Fortunately, Jana's brother has a large empty garage that they can operate in for the first year which saves them from renting space. They are going to contribute to his utility costs as listed in the chart below. Because they are selling to businesses, their marketing budget is largely allocated to personal selling (reflected in payroll costs). Jana and Cindy have $5,500 set aside as their beginning cash balance. Going forward, they do not want their cash balance to go below $3,000. Because they have strong personal credit histories and other sources of household income from their respective partners, they have been approved for a bank line of credit at a rate of 6%. If they need to use this line of credit, they will pay interest in the month following borrowing. Once they have a cash surplus, they will pay down as much of the outstanding line of credit as possible. Round all amounts up to the nearest dollar when preparing the cash budget. Once you complete the cash budget and break-even, provide advice to Jana and Cindy about how to interpret and make decisions with the resulting numbers. Sales Payroll Utilities Insurance Website Business License Equipment Lease Startup Costs UP-PACK - Combined Question Quiz Question 1 MAR JAN 12000 8400 500 375 125 300 2200 3000 FEB 12000 18,000 8400 8400 500 375 125 500 375 125 2200 2200 APR 18,000 8400 500 375 125 2200 MAY 20,000 8400 500 375 125 2200 JUNE 26,000 8400 500 375 125 2200 Question 3 Selena would like to start a new venture after she finishes school. She projects that her fixed costs will be $68092. She expects that she can sell her product for $16 and that her variable costs per unit will be $8. She knows she has done her research but she is still worried about the risk involved with this new venture. How many units would she have to sell to break-even? Question 4 Jerry and Ben would like to open a new business next year. They have worked hard on their cost projections and believe they can start with fixed costs of $60,000. Their customer research indicates that they can sell their product for $12.00 and variable costs are expected to be $3.50 per unit. They know they have done plenty of research but are still nervous about the risk involved with this new venture. How many units would Jerry and Ben have to sell to break-even? Question 5 Sheldon is considering opening a hockey clinic as a side business but is worried about whether he can manage the risk. He anticipates fixed costs of $140,000, sales of $400,000 and costs of goods sold of $80,000. What sales volume would Sheldon need to break-even?
Expert Answer:
Answer rating: 100% (QA)
Budget for Upcycling Business Jana and Cindy are planning to launch UPPACK a business that upcycles disposable masks into high quality packaging material They think it can be a viable business but the... View the full answer
Related Book For
Posted Date:
Students also viewed these finance 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...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Googles ease of use and superior search results have propelled the search engine to its num- ber one status, ousting the early dominance of competitors such as WebCrawler and Infos- eek. Even later...
-
The RRR Company has a target current ratio of 2.4. Presently, the current ratio is 3.3 based on current assets of $6,567,000. If RRR expands its inventory using short- term liabilities (maturities...
-
Computing and Interpreting the Current Ratio Calculate the current ratio for Sals Pizza Company at the end of 2007 and 2008, based on the following data: What does the result suggest about the...
-
Determine the vertical rise h of the load W during 10 seconds if the hoisting drum draws in cable at the constant rate of 180 mm/s. M W Problem 2/221
-
What is ITSM?
-
The balance sheet for Bukin Corporation follows. Current assets ............. $ 300,000 Long-term assets (net) .......... 950,000 Total assets ............... $1,250,000 Current liabilities...
-
Suppose the following information was taken from the 2025 financial statements of FedEx Corporation, a major global transportation/delivery company. (in millions) 2025 2024 Accounts receivable...
-
Wayland Custom Woodworking is a firm that manufactures custom cabinets and woodwork for business and residential customers. Students will have the opportunity to establish payroll records and to...
-
1. Find the current through resistor a ) in the figure. (Figure 1) Express your answer to two significant figures and include the appropriate units. 2. Find the potential difference across resistor a...
-
2. Usually, Rebecca's bakery posts petty cash transactions and replonishes the account, which holds $350, every week. Rebecca's accountani moxed her petty cash receipts for the week of February 1-7...
-
Part 1: Prior Year WTG had numerous active contracts at the beginning of the current year. All of these contracts have been analyzed correctly. WTG had been paid in full for all of these contracts as...
-
Answer each of the following questions. Model each problem with input cells to allow for flexibility in answering similar questions. Interest rates are stated as simple annual rates. 1. If you invest...
-
2.34 Make a SolidWorks part of the Piston" (drawing attached). All dimensions are in inches. You must use a "revolve" command to make the body of the piston. Submit your part file. 1.740 1 1.44 B .44...
-
Visual GmbH is a small sized German company that produces motion detectors for the B2B sector. It is an innovative company which received special recognition in their market for a video camera...
-
The following rules illustrate traditional economic policy theory in terms of regulating a government's economy. a) If the annual growth rate is less than 1%: If inflation is less than 3%,...
-
Show that, given a maximum flow in a network with m edges, a minimum cut of N can be computed in O(m) time.
-
Discuss the reasons for using lifo in an inflationary economy.
-
What is a decision tree and how is it used?
-
Parsons Company's total maintenance cost for the past 10 months is $50,000. Some of the maintenance activity appears related to the operation of machinery, and the accountant wants to determine...
-
Which of the following taxpayers is engaged in a specified service trade or business? (a) A lawyer (b) An architect (c) A professional soccer player (d) A freelance writer who publishes articles and...
-
D, a single taxpayer, holds a 25% ownership interest in an LLC that operates a department store. Ds allocable share of net operating income from the LLC is \($100,000\) for the year. D also works...
-
A and B form the AB equal general partnership. A contributes \($10,000\) cash and a depreciable asset with an adjusted basis of \($40,000\) and a fair market value of \($90,000.\) B contributes...
Study smarter with the SolutionInn App