OK, here is the problem. I attached what I have already done…it is supposed to be done in excel.Part OneBig Als Pizza, Inc., a new subsidiary of Big Als Pizza Emporium, has been establishedto produce partially baked, fl ash-frozen, 16-inch meat pizzas to be soldwholesale to grocery and convenience stores and school cafeterias. As a new entrantto the market, the companys goal is to produce and sell 319,500 pizzas in the firstyear. Big Als plans to keep approximately a one-month supply of frozen pizzas infinished goods inventory.Big Als Pizza will have 10 production lines. Each of the five workers on eachline will be responsible for one of the five stages of production: dough, sauce, cheese,toppings, and packaging. Each of the 10 production lines can produce 20 meat pizzasper hour.Big Als deals exclusively with Pizza Products, Inc. to purchase raw materialsand equipment. All ingredients (dough, sauce, cheese, meat, etc.) are fresh, and BigAls generally holds a two- or three-day supply in raw materials inventory.The projected material costs are as follows:Material Costs (per pizza)Complete dough shells $.12Complete sauce package .20Complete cheese package .08Complete meat package .30Complete assembly package .04Direct labor employees are paid on an hourly basis according to hours worked.Once production-line workers finish a days scheduled production, they are senthome. They can work a maximum of 8 hours each day without earning overtime.The overtime premium is an additional 50 percent of the basic hourly rate of $7.50per hour. Supervisors and other indirect labor employees are salaried.Labor Costs (estimated)Rate for direct labor $7.50 per hour (plus $2.50 per hour in fringe benefits)Indirect labor (per month):Supervisor (including fringe benefits) $3,000Other indirect labor (including fringe benefits) $2,000Overhead Costs (estimated, per month)Rent on production facility $1,000Utilities $1,475Other overhead:Indirect material $2,500Maintenance costs $1,500Quality inspection costs $2,000Equipment (lease costs) $2,500Selling and Administrative Costs (estimated, per month)Administrative salaries $4,000Salaries of sales staff $5,000Product promotion and advertising $2,000Rent on offi ce space for staff $2,000Utilities and insurance $ 500Lease of offi ce furniture and equipment $ 800During the fi rst year of operation, Big Als estimated that they would produce346,125 pizzas but actually produced 336,033 pizzas. Direct material costs were$248,664 and direct labor costs were $840,082 for 84,008 hours worked. Estimatedoverhead costs for the year were $191,700 while actual overhead was $193,000.Required:A. What is an appropriate cost driver for allocating overhead to pizzas in year 1?B. Using normal costing, compute the cost of each of the 336,033 meat pizzas producedin year 1. (Round down to nearest dollar.)C. Was overhead over- or underapplied during the year? By how much? Why doyou think overhead was over- or underapplied during the year?Part TwoIn its second year of operations, Big Als has decided to expand the product line byproducing a veggie pizza. This new pizza will require the purchase of a veggie packagefrom Pizza Products at a cost of $.18 per pizza. Of course, the meat packagewill not be required. All other ingredients and prices remain the same.The veggie toppings require additional processing time (cutting and dicing) thatlimits production to 18 veggie pizzas per hour per assembly line. The new veggiepizza is not expected to affect sales of the meat pizza. In the second year of operations,Big Als expects to produce about 352,800 meat pizzas and 25,200 veggie pizzas .Increasing production is expected to increase overhead costs by 5 percent inyear 2. Direct labor costs per hour are not expected to change, and the number oflabor hours is estimated to be 94,500. The costs of product promotion and advertisingare expected to increase to $3,000 per month. All other selling and administrativecosts are expected to remain the same as in year 1.Actual production in year 2 was 345,132 meat pizzas and 25,200 veggie pizzas.Direct material costs transferred to WIP were $259,000 for the meat pizzas and$15,624 for the veggie pizzas. Direct labor costs were $862,830 for the meat pizzasand $70,010 for the veggie pizzas, representing 86,283 and 7,001 direct laborhours, respectively. Actual overhead costs were $203,600.Purchases of raw materials during year 2 were $276,138. Sales during year 2were $1,701,410 for 340,282 meat pizzas and $121,275 for 23,100 veggie pizzas.SCHEDULE OF BEGINNING AND ENDING INVENTORY AMOUNTS FOR YEAR 2.Beginning Inventory
OK, here is the problem.it is supposed to be done in excel. Part One Big Al’s Pizza, Inc.
Give us your instructions.
Select the type of service you need: writing, calculations, or programming. We’ve created an intuitive order form that tells you what information to enter and where, so make sure to fill out each required field. Also, make your requirements as specific as possible. Don’t rush! Take your time and explain everything in detail how it works.
Proceed to checkout and enter your credit card details or PayPal login, how to pay. Follow the payment provider’s instructions to confirm the transaction.
Now your order is in our system! We’ll start processing it right away.
Place Your Order
Frequently asked questions
Is your service confidential?
When you place an order with our company, we ask you to provide us with such personal information as your name, phone number, and email address. We need this data to keep you updated on the important things related to your order or account.
Is there a possibility of plagiarism in my completed order?
We complete each paper from scratch and in order to make you feel safe regarding its authenticity, we check it for plagiarism before its delivery. To do that, we use our in-house software, which can find not only copy-pasted fragments but even paraphrased pieces of text. Unlike popular plagiarism detection systems that are used by most universities (e.g. Turnitin.com), we do not report to any public databases—therefore, such checking is safe.
We provide a plagiarism-free guarantee that ensures your paper is always checked for its uniqueness.
Is there a money-back guarantee? If yes, how can I receive a refund?
You can certainly get your money back in several cases. You can receive a full refund if you have paid for your order twice or if you have placed two identical orders. In case your paper was late or the quality of the paper does not correspond to your expectations, you will get compensation for these issues.
Do you keep a database of pre-written essays?
No, we do not have such a database. All papers you order from us are written from scratch. This means your paper is unique and has never been published before—neither will it be published after we deliver it to you.
When will my custom paper be done?
While placing an order with WritersHub, you can choose a period of time within which a paper should be delivered to you. The countdown until the specified deadline starts automatically from the moment we receive your payment in our system. For example, if you pay for your order at 6pm on Monday and choose a 3-day delivery option, you will receive your custom paper by 6pm on Thursday.
Remember that a writer needs a sufficient amount of time in order to conduct thorough research. Therefore, please choose the most suitable deadline when you place an order. Moreover, the later you need your paper to be delivered to you, the cheaper it will be. Thus, you will be able to save your money while your writer will have enough time to work on your order and ensure its quality.
Make sure you upload all the additional materials at the very beginning. If you fail to do that, the deadline for your order will be postponed as well.
I haven’t received my custom paper by the deadline. What should I do?
Let us know immediately about that. You can do it by writing a message on Facebook or email us. Our support manager will carefully examine your order and will assist you with it right away. The reasons for late delivery may vary from time to time. It can happen that you have entered a wrong email address or your spam filter does not allow you to receive emails from us. It is also possible that the writer is waiting for your reply and can not continue working without your assistance, or we are checking the work for plagiarism. Whatever the case may be, contact us if you have any problems with getting your order on time.