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

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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