FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
Perfect Parties, Inc. has several divisions, 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 Division Budget Performance Report.
Please provide me with the FORMULAS needed for each yellow cell. for ex: the planning budget for the number of parties would be =b10 which would then make the answer 80. thank you
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps
Knowledge Booster
Similar questions
- The Document Creation Center (DCC) for Arlington Corp. provides photocopying and document services for three departments in the Minneapolis office. The following budget has been prepared for the year. Available capacity Budgeted usage: Software Development Training Management Cost equation 8,100,000 pages Multiple Choice $162,000. $116,740. $100,370. $45,630. 1,700,000 pages 3,100,000 pages 2,500,000 pages $285,000 + $0.02 per page If DCC uses a dual-rate for allocating its costs based on usage, how much cost will be allocated to the Software Development Department?arrow_forwardDear Bartleby,could you please provide assistance with preparing a materials purchase budget, thank you, as indicated after this. d. Prepare a materials purchases budget in pounds, by month and in total, for the second quarter of 2019. Soprano Co. is in the process of preparing the second quarter budget for 2019, and the following data have been assembled: The company sells a single product at a selling price of $40 per unit. The estimated sales volume for the next six months is as follows: March 6,000 units June 8,000 units April 7,000 units July 9,000 units May 10,000 units August 6,000 units All sales are on account. The company's collection experience has been that 40% of a month's sales are collected in the month of sale, 55% are collected in the month following the sale, and 5% are uncollectible. It is expected that the net realizable value of accounts receivable (i.e., accounts receivable less allowance for uncollectible accounts) will be…arrow_forwardWe discuss how to prepare the different component budgets of theoperating budget, including the sales, production, direct materials,direct labor, manufacturing overhead, cost of goods sold, andselling and administrative expense budgets. We also discuss howto use information from all of these operating budgets to prepare abudgeted income statement. Knowledge Check 05WellWheats, Inc. produces breakfast cereal and sells each box, or unit, for $7.The company is projecting sales of 1,000 units for the month of March. The totalcost of producing one unit includes $2 for direct materials, $1 for direct labor,and $0.50 for manufacturing overhead.Calculate the cost of goods sold for the month of March.arrow_forward
- please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)arrow_forwardDinham Kennel uses tenant-days as its measure of activity; an animal housed in the kennel for one day is counted as one tenant-day. During March, the kennel budgeted for 3,400 tenant-days, but its actual level of activity was 3,460 tenant-days. The kennel has provided the following data concerning the formulas used in its budgeting and its actual results for March: Data used in budgeting: Revenue Wages and salaries Food and supplies Facility expenses Administrative expenses Total expenses Actual results for March: Fixed Variable element per element per month tenant-day $0 $ 34.30 $ 2,300 $ 7.30 1,300 13.80 7,800 6,300 $ 17,700 2.80 0.40 $ 24.30 Revenue $ 115,625 Wages and salaries $ 28,530 Food and supplies $ 49,580 Facility expenses $ 16,500 Administrative expenses $ 7,093 The spending variance for facility expenses in March would be closest to:arrow_forwardCreate a budget for the Bright Lights Awards using the following information: We have been allocated a budget of $25,000 and there will be 2500 people in attendance. The theme for the ceremony is The Great Gatsby Gala and we decided to book the Westin Habour Castle Conference Centre in Downtown Toronto for the event, which will cost $2000 for 8 hours on the evening of Saturday 6 April. We have hired an event planner who will plan and provide everything from deorations, flowers and to contractors according to our theme for all the set up and have received an invoice of $5000 for his services. Our trusted and regular Caterer has charged us $10,000 for food and snacks for the ceremony. For entertainment, we've hired a jaz band for $500 to play music for the ceremony and have created slideshows in celebration of all achieved this year and have asked one of our committee members to MC the event. To save costs, we will use the company drones for videography and photographs and have just…arrow_forward
- Use 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_forwardIs ABC Manufacturing is properly using the budget process to plan for next year's expenses? You have just been hired at ABC Manufacturing, and your supervisor has invited you to sit in on today's budget meeting. You are given a copy of the following proposed budget for next year to review. The budget is being used by ABC to plan for next year. Your supervisor tells you right before the meeting, "We always overestimate because the president always makes us cut the budget by 20%, and besides, I really want to go to that conference in Las Vegas next year." He continued," I have really worked hard this year and put in a lot of overtime so I deserve it." ABC MANUFACTURING Budgeted Income Statement // For the Year Ended Dec. 31, 20XX REVENUE: Sales COST OF GOODS SOLD: Cost of Goods Sold GROSS PROFIT EXPENSES: Advertising Cleaning Insurance Phone Rent Supplies Taxes Training/Education Utilities Wages Total Expenses NET INCOME 9,500 1,800 28,000 3,600 24,000 6,500 10,000 9,800 8,500 150,000…arrow_forwardThe Document Creation Center (DCC) for Arlington Corp. provides photocopying and document services for three departments in the Minneapolis office. The following budget has been prepared for the year. Available capacity 9,400,000 pages Budgeted usage: Software Development 2,460,000 pages Training 3,600,000 pages Management 2,940,000 pages Cost equation $307,000 + $0.06 per page If DCC uses a dual-rate for allocating its costs based on usage, how much cost will be allocated to the Management Department? Multiple Choice $247,887. $276,687. $256,878. $130,829.arrow_forward
- The Document Creation Center (DCC) for Arlington Corp. provides photocopying and document services for three departments in the Minneapolis office. The following budget has been prepared for the year. Available capacity 8,100,000 pages Budgeted usage: Software Development 1,700,000 pages Training 3,100,000 pages Management 2,500,000 pages Cost equation $285,000 + $0.02 per page If DCC uses a dual-rate for allocating its costs based on usage, how much cost will be allocated to the Software Development Department? Multiple Choice $116,740. $100,370. $45,630. $162,000.arrow_forwardNozama.com Inc. sells consumer electronics over the Internet. For the next period, the budgeted cost of the sales order processing activity is $179,400, and 13,800 orders are estimated to be processed. a. Determine the activity rate of the sales order processing activity. per sales order b. Determine the amount of sales order processing cost that Nozama.com would receive if it had 7,900 sales orders.arrow_forwardPrepare 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…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education