Prepare a sales budget and production budget

Assignment Help Accounting Basics
Reference no: EM132782697

The Director of Operations and Sales has secured a distribution channel for your new beverage line. It is anticipated that TBC will be able to sell a case of your beverage for $45 each. Sales are estimated to be 15,000 units in January and 18,000 units in February. Each case will require 3 oz. of sugar syrup (costing $3.00 per oz.) and 2 oz. of flavoring (cost $2.50 per oz.). Production will also require 30 minutes of direct labor at a rate of $18 per hour. Desired inventory levels are:

 

January 1

February 28

March 31

Beginning inventory

 

 

 

Finished goods

4,500

4,900

5,000

Direct materials: flavoring

8,500

9,100

9,200

Direct materials: sugar syrup

11,200

12,000

13,000

problem 1: Prepare a sales budget, production budget, direct materials budget for flavoring and sugar syrup, and a direct labor budget. Prepare all budgets in excel. (You will prepare January and February).

Reference no: EM132782697

Questions Cloud

What amount of profit is recognized for flea co : What amount of profit is recognized in 20x3? Flea Co. entered Into a P10,000,000 contract to construct a multi-purpose recreational facility
What financial commitments the company would be liable : What advantages (if any) each choice would provide the company and what financial commitments the company would be liable for under each option.
What is the horizontal distance tavelled by the projectile : What is the time of the projectile is in the air? What is the horizontal distance tavelled by the projectile?
What is the velocity of the 450g billard ball : A 10g ping pong ball travelling at 2.0m/s hits a billiard ball (at rest) and bounce backwards at the same speed. What is the velocity of the 450g billard ball?
Prepare a sales budget and production budget : Prepare a sales budget, production budget, direct materials budget for flavoring and sugar syrup, and a direct labor budget. Prepare all budgets in excel
Determine the net force and bearing of the couch : Bob pulls with 500N due south while Jen pulls with 650N due east. Determine the net force and bearing of the couch being moved.
What is the final kinetic energy of the crate : What is the final kinetic energy of the crate? What is the displacement of the crate when it reaches this speed?
Determine the final temperature of the silver and water : Determine the final temperature of the silver and water given c silver=2.4*10^2 J/kg.K
What is the output force of the brake piston : A vehicle has a master cylinder with a piston diameter of 5/8". The brake caliper piston has a diameter of 1 1/2".

Reviews

Write a Review

Accounting Basics Questions & Answers

  Write a response on given problem

Using the accompanying explanations of each IT strategic role, suggest the appropriate IT strategic role (automate, informate or transform) for the following.

  Describe cybersecurity act

Describe Cybersecurity Act of 2015 What do you see as the advantages and disadvantages of having this piece of legislation in place?

  Journalize the assignment of overhead to the assembly

Weber Company purchases $54,100 of raw materials on account, and it incurs $64,900 of factory labor costs.

  Explain the asset substitution effect of social security

What is the impact on the labor productivity of the typical worker? Explain. Create a graph: Graph data should be the impact on the labor productivity of the typical worker compared to their savings decisions.

  Walsh company manufactures and sells one product

Walsh Company manufactures and sells one product. The following information pertains to each of the company's first two years of operations: Variable costs per unit:

  Did the fbi act under the color of any international laws

Did the FBI act under the color of any international laws or compacts, or did they "go off the reservation?" Do the FBI's actions stand up to scrutiny under current US cyber laws? Have there been other, more recent examples of cases in which US la..

  Evaluate the quality of the reasoning in the given source

Once you have formulated your question, conduct research from non-scholarly sources on the internet (e.g., news articles, op-eds, etc.).

  How much cost would be allocated in the first-stage

How much cost, in total, would be allocated in the first-stage allocation to the Setting Up activity cost pool

  Determine the correct inventory amount on december

Determine the correct inventory amount on December, The goods were received at Natali on January 8. They were not included in Josef's physical inventory

  Compute the anticipated cash inflow for the month of august

The company's past experience indicates that 70% of accounts receivable are collected in the month of sale, The anticipated cash inflow for month of August is

  What is the price per share

The balance sheets of Roop Industries are shown below. The 12/31/2006 value of operations is $651 million and there are 10 million shares of common equity.

  How are assets classified to determine tax treatment

Asset Classifications. How are assets classified to determine tax treatment on disposition? The response must be typed.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd