Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780134128528
Author: Karen W. Braun, Wendy M. Tietz
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 9, Problem 9.75ACT
Budgeting for a Single Product
In this activity, you will be creating budgets for a single product for each of the months in an upcoming quarter. Select a product that you could purchase in large quantities (at a Sam’s Club or other warehouse retail chain) and repackage into smaller quantities to offer for sale at a sidewalk cafe, a sporting event, a flea market, or other similar venue. Investigate the price and quantity at which this product is available at the warehouse. Choose a selling price for the smaller (repackaged) package. Make reasonable assumptions about how many of the smaller units you can sell in each of the next four months (you will need the fourth month’s sales in units for the operating budgets).
Basic Discussion Questions
- 1. Describe your product. What is your cost of this product? What size (quantity) will you purchase? At what price will you sell your repackaged product? Make projections of your sales in units in each of the upcoming three months.
- 2. Estimate how many hours you will spend in each of the upcoming three months doing the purchasing, repackaging, and selling. Select a reasonable wage rate for yourself. What will your total labor costs be in each of the upcoming three months?
- 3. Prepare a sales budget for each of the upcoming three months.
- 4. Prepare the direct material budgets for the upcoming three months, assuming that you need to keep 10% of the direct materials needed for next month’s sales on hand at the end of each month (this requirement is why you needed to estimate unit sales for four months).
- 5. Prepare a direct labor budget (for your labor) for each of the upcoming three months.
- 6. Think about any other expenses you are likely to have (i.e., booth rental at a flea market or a vendor license). Prepare the operating expenses budget for each of the upcoming three months.
- 7. Prepare a
budgeted income statement that reflects the budgets you prepared, including the sales budget, direct materials budget, direct labor budget, and the operating expenses budget. This budgeted income statement should include one column for each of the three months in the quarter, and it should also include a total column that represents the totals of the three months. What is your projected profit by month and for the quarter?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
For each situation, select which type of budget you must prepare.
Situation
You have to assess the likely costs needed to participate in a trade show. A big purchase is required
-a new demonstration booth.
It will take a lot of time to plan for a trade show, and this is not your only responsibility. You need a
plan to ensure that you complete the full range of duties.
You are planning an appearance for your company at a trade show. You must forecast the revenue
your company may earn as a result of your participation.
Financial Operating
Nonmonetary
Prepare a 12-month Master Budget for a company of your choosing. It can be a company that you are closely connect too or one randomly selected. COMPLETED IN EXCEL.
As you are preparing the Master Budget, some information is NOT provided. You are required to decide or predict or forecast this information.
Provide an introduction for the company you have chosen. The introduction should include the following:
Name of company
Location of company
Name of owner
Nature of the business.
Type of product
Fiscal period
For the company that you have selected - Prepare a 12-month Master Budget. Your submission must show each month’s activities.
Here are some considerations to include in preparing the budget:
You must forecast your sales, purchases, direct labour and manufacturing overhead for each month and any other information as required
All sales are on accounts
Expected collections are to be 50% in the month of the sale, 30 % in the first month following the sale, and 20% in the second…
In this task you are provided with an excel file with 2 spread sheets (Budgeted Rooms Revenue Sheet, Actual Rooms Revenue sheet) with the actual figures on the rooms for a given quarter. You are required to calculate the actual revenue that has been generated for each month in the given quarter based on the actual occupancy rate.
Calculate the following details using the appropriate sheet as per the given instructions
Budgeted Rooms Revenue Sheet
Refer to the projected data sheet.
In this sheet first calculate the total projected/forecasted revenue per room type for all 365 days.
You are also required to calculate total projected/forecasted revenue per room type for each month for Jan, Feb and Mar.
Calculate the total rooms for each month
Calculate the Total Revenue for all room types for each month
Calculate the total projected revenue for 3 months (Jan, Feb and Mar)
Actual Rooms Revenue Sheet
In this sheet you are provided with the Actual occupancy for each month.
Calculate the…
Chapter 9 Solutions
Managerial Accounting (5th Edition)
Ch. 9 - (Learning Objective 1) Which term describes the...Ch. 9 - (Learning Objective 1) Benefits of budgeting...Ch. 9 - Prob. 3QCCh. 9 - Prob. 4QCCh. 9 - Prob. 5QCCh. 9 - Prob. 6QCCh. 9 - Prob. 7QCCh. 9 - Prob. 8QCCh. 9 - Prob. 9QCCh. 9 - Prob. 10QC
Ch. 9 - Short Exercises S9-1 Order of preparation and...Ch. 9 - Explain why companies use zero-based budgeting...Ch. 9 - Understanding key terms and definitions (Learning...Ch. 9 - Sales Budget (Learning Objective 2) Jefferson...Ch. 9 - Production budget (Learning Objective 2) Nichols...Ch. 9 - Direct materials budget (Learning Objective 2)...Ch. 9 - Prob. 9.7SECh. 9 - Prob. 9.8SECh. 9 - Prob. 9.9SECh. 9 - Prob. 9.10SECh. 9 - Prob. 9.11SECh. 9 - Cash payments budget (Learning Objective 3) Finley...Ch. 9 - Cash budget (Learning Objective 3) SaveCo...Ch. 9 - Prob. 9.14SECh. 9 - Prob. 9.15SECh. 9 - Identify ethical standards violated (Learning...Ch. 9 - Prob. 9.17AECh. 9 - Sales budget for a retail organization (Learning...Ch. 9 - Prob. 9.19AECh. 9 - Production budget (Learning Objective 2) Hoffman...Ch. 9 - Direct materials budget (Learning Objective 2)...Ch. 9 - Production and direct materials budgets (Learning...Ch. 9 - Direct labor budget (Learning Objective 2)...Ch. 9 - Manufacturing overhead budget (Learning Objective...Ch. 9 - Operating expenses budget and an income statement...Ch. 9 - Budgeted income statement (Learning Objective 2)...Ch. 9 - Prob. 9.27AECh. 9 - Cash collections budget (Learning Objective 3)...Ch. 9 - Cash payments budget (Learning Objective 3) The...Ch. 9 - Prob. 9.30AECh. 9 - Prob. 9.31AECh. 9 - Budgeted balance sheet (Learning Objective 3) Use...Ch. 9 - Prob. 9.33AECh. 9 - Prob. 9.34AECh. 9 - Cost of goods sold, inventory, and purchases...Ch. 9 - Cost of goods sold, inventory, and purchases...Ch. 9 - Prob. 9.37BECh. 9 - Prob. 9.38BECh. 9 - Prob. 9.39BECh. 9 - Prob. 9.40BECh. 9 - Direct materials budget (Learning Objective 2) Moe...Ch. 9 - Prob. 9.42BECh. 9 - Prob. 9.43BECh. 9 - Manufacturing overhead budget (Learning Objective...Ch. 9 - Prob. 9.45BECh. 9 - Prob. 9.46BECh. 9 - Prob. 9.47BECh. 9 - Prob. 9.48BECh. 9 - Prob. 9.49BECh. 9 - Combined cash budget (Learning Objective 3)...Ch. 9 - Sales and cash collections budgets (Learning...Ch. 9 - Prob. 9.52BECh. 9 - Prob. 9.53BECh. 9 - Prob. 9.54BECh. 9 - Prob. 9.55BECh. 9 - Prob. 9.56BECh. 9 - Comprehensive budgeting problem (Learning...Ch. 9 - Cash budgets under two alternatives (Learning...Ch. 9 - Comprehensive summary problem (Learning Objectives...Ch. 9 - Prob. 9.60APCh. 9 - Cash budgets (Learning Objective 3) Elis...Ch. 9 - Prob. 9.62APCh. 9 - Cost of goods sold, inventory, and purchases...Ch. 9 - Prob. 9.64APCh. 9 - Problems Group B P9-65B Comprehensive budgeting...Ch. 9 - Cash budgets under two alternatives (Learning...Ch. 9 - Comprehensive summary problem (Learning Objectives...Ch. 9 - Prob. 9.68BPCh. 9 - Cash budgets (Learning Objective 3) Ivans...Ch. 9 - Combined cash budget and a budgeted balance sheet...Ch. 9 - Prob. 9.71BPCh. 9 - Prepare comprehensive budgets for a retailer...Ch. 9 - Prob. 9.73SCCh. 9 - Discussion Questions 1. The sales budget is the...Ch. 9 - Budgeting for a Single Product In this activity,...Ch. 9 - Ethics and budgetary slack (Learning Objectives 1,...Ch. 9 - Prob. 9.77ACT
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Norton Company, a manufacturer of infant furniture and carriages, is in the initial stages of preparing the annual budget for the coming year. Scott Ford has recently joined Nortons accounting staff and is interested in learning as much as possible about the companys budgeting process. During a recent lunch with Marge Atkins, sales manager, and Pete Granger, production manager, Ford initiated the following conversation. FORD: Since Im new around here and am going to be involved with the preparation of the annual budget, Id be interested in learning how the two of you estimate sales and production numbers. ATKINS: We start out very methodically by looking at recent history, discussing what we know about current accounts, potential customers, and the general state of consumer spending. Then, we add that usual dose of intuition to come up with the best forecast we can. GRANGER: I usually take the sales projections as the basis for my projections. Of course, we have to make an estimate of what this years closing inventories will be, which is sometimes difficult. FORD: Why does that present a problem? There must have been an estimate of closing inventories in the budget for the current year. GRANGER: Those numbers arent always reliable since Marge makes some adjustments to the sales numbers before passing them on to me. FORD: What kind of adjustments? ATKINS: Well, we dont want to fall short of the sales projections so we generally give ourselves a little breathing room by lowering the initial sales projection anywhere from 5 to 10 percent. GRANGER: So, you can see why this years budget is not a very reliable starting point. We always have to adjust the projected production rates as the year progresses, and of course, this changes the ending inventory estimates. By the way, we make similar adjustments to expenses by adding at least 10 percent to the estimates; I think everyone around here does the same thing. Required: 1. Marge Atkins and Pete Granger have described the use of budgetary slack. a. Explain why Atkins and Granger behave in this manner, and describe the benefits they expect to realize from the use of budgetary slack. b. Explain how the use of budgetary slack can adversely affect Atkins and Granger. 2. As a management accountant, Scott Ford believes that the behavior described by Marge Atkins and Pete Granger may be unethical and that he may have an obligation not to support this behavior. By citing the specific standards of competence, confidentiality, integrity, and/or credibility from the Statement of Ethical Professional Practice (in Chapter 1), explain why the use of budgetary slack may be unethical. (CMA adapted)arrow_forwardMolly Malone is starting her own company in which she will produce and sell Molly’s Macaroons. Molly is trying to learn about the budget process as she puts her business plan together. Help Molly by explaining the optimal order for preparing the following budgets and schedules and why this is the optimal order. budgeted balance sheet budgeted income statement capital asset budget cash budget cash collections schedule cash payments schedule direct materials budget direct labor budget master budget manufacturing overhead production budget sales budget selling and administrative budgetarrow_forwardWhich of the following is a benefit of using budget-management software? (check all that apply). Allows companies to determine the exact amount of sales that will be achieved in the upcoming fiscal period. Allows companis with multiple business segments to comine financial data from each of its segments to prepare company-wide budgeted financial Allows managers to access the budget from several locations through the internet. Allows managers to perform sensitivity analysis on each individual business segment.arrow_forward
- Perfect Parties, Inc. has several divislons, one of which provides birthday parties at their facility, and has provided the actual and planning budget results for the month of June. The Controller has asked you prepare the Birthday Party Dlvislon Budget Performance Report. Use the Information Included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "=E11" was entered, the formula would output the result from cell E11, or 80 In this example. • Basic Math functions: Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys: - (plus sign to add), - (minus sign to subtract). * (asterisk sign to multiply), and (forward slash to divide). From the Excel Simulation below, If in a blank cell "=E13-F13" was entered, the formula would add the values from those cells and output…arrow_forwardPrior midnight March 11, post at least once about this week's Wiley assignment. You may post asking your fellow learners for help or share your own insight as you work through the assignment. Some guiding points: - - What is the first step you will take to successfully complete a budget for yourself ? - What are some of the challenges in creating a budget for a company?arrow_forwardAssume that you are starting your own coffee shop. You will need to develop budgeted income statement and balance sheet for the next three years. Your goal is to apply the budget concepts and formulate strategies for operational sustainability. Task: Model Financial Statement Budgets for a Coffee Shop a. Income statement budget model for 3 years. b. Balance sheet budget model for 3 years. Hints (USE $ as currency + make it a low budget business + see the attached tables as refrernce to the kind of required tables)arrow_forward
- Refer to the information regarding Stillwater Designs above.Required:1. Prepare a sales budget for each quarter of 20X1 and for the year in total. Show sales byproduct and in total for each time period.2. CONCEPTUAL CONNECTION How will Stillwater Designs use this sales budget?arrow_forwardUse the data in the following table to prepare the Budget Performance Report for Sole Purpose Shoe Company for September. Budget Performance Report Sarah has learned a lot from you over the past two months, and has compiled the following data for Sole Purpose Shoe Company for September using the techniques you taught her. She would like your help in preparing a Budget Performance Report for September. The company produced 2,500 pairs of shoes that required 8,750 units of material purchased at $8.20 per unit and 6,750 hours of labor at an hourly rate of $8.90 per hour during the month. Actual factory overhead during September was $20,250. When entering variances, use a negative number for a favorable cost variance, and a positive number for an unfavorable cost variance.arrow_forward1. What is the total budgeted indirect cost at the Elmore store in January 2018? What is the total budgeted cost of each activity at the Elmore store for January 2018? What is the budgeted indirect cost of each product category for January 2018? 2. Which product category has the largest fraction of total budgeted indirect costs? 3. Given your answer in requirement 2, what advantage does Maclin's Corner gain by using an activity-based approach to budgeting over, say, allocating indirect costs to products based on cost of goods sold?arrow_forward
- Barlow Company manufactures book bags and has provided the following information for June 2018: E (Click the icon to view the information.) Requirements 1. Prepare a flexible budget performance report. (Hint: You will need to calculate the flexible budget amounts for 10,000 units.) 2. As the company owner, which employees would you praise or criticize after you analyze this performance report? Requirement 1. Prepare a flexible budget performance report. (Hint. You will need to calculate the flexible budget amounts for 10,000 units.) (Enter a "0" for any zero balances. For any $0 variances, leave the Favorable (F)/Unfavorable (U) input blank. Enter all amounts as positive values.) Barlow Company Flexible Budget Performance Report For the Month Ended June 30, 2018 - X 1 Data Table (1) - (3) (3) - (5) Budget Flexible Sales Static Budget 11,000 Amounts Actual Budget Flexible Volume Static Actual Results Units 10,000 Per Unit Results Variance Budget Variance Budget Sales Revenue $ 174,000 $…arrow_forwardPlease write a budget plan and IMC Gantt chart for an event that involves selling zongzi on Dragon Boat Festival and donating the proceeds to stray animals for three weeks, Wednesday, Thursday and Friday of each week.arrow_forwardScholar Suppliers manufactures backpacks for students. The backpacks come in two sizes: Small, and Large. Scholar Suppliers anticipates the following sales volumes and prices for the coming period: Size Sales Volume Selling Price Small 3,000 backpacks $25 each Large 6,000 backpacks $75 each What is the budgeted level of revenue for the coming period?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Inspection and Quality control in Manufacturing. What is quality inspection?; Author: Educationleaves;https://www.youtube.com/watch?v=Ey4MqC7Kp7g;License: Standard youtube license