CourseLover

(12)

$10/per page/Negotiable

About CourseLover

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Engineering,Health & Medical,HR Management,Law,Marketing,Math,Physics,Psychology,Programming,Science Hide all
Teaching Since: May 2017
Last Sign in: 287 Weeks Ago, 2 Days Ago
Questions Answered: 27237
Tutorials Posted: 27372

Education

  • MCS,MBA(IT), Pursuing PHD
    Devry University
    Sep-2004 - Aug-2010

Experience

  • Assistant Financial Analyst
    NatSteel Holdings Pte Ltd
    Aug-2007 - Jul-2017

Category > Accounting Posted 19 Dec 2017 My Price 10.00

Buns Bakery Basic Information For Year Ended December 31, Year 2

Hello. I need some assistance. I need the excel assignment attached (the budget) to be in the format of the template attached(for it too resemble that exact outline). Once again both are attached. Thank you so incredibly much for your help.

2014 Quarter 3 Quarter 4 Sales: Mufns doz 45000 Selling price per doz $5.50 Cookies doz 65000 Selling price per doz $4.75 Bread doz 85000 Selling price per doz $5.25 Cash sales 10% Credit sales 90% CollecTon From AR 30% within quarter 45% next quarter 25% second quarter Sales in dollars 802000 1002500 Quarter days taken 90 ±inished goods inventory in days 2 Mufns QuanTty oF 1 batch 8 Direct labor hours per batch mixer 0.5 Direct labor hours per batch baker 0.25 Packaging labor 1 Direct labor hour packaging 0.25 Direct labor rate per hour baker $7.50 mixer $8 packer $6.50 Direct material per doz $1.79 Payment For AP 85% in same quarter 15% in next quarter Accounts Payable oF 2014 4 quarter $31,648 Variable OH per DLH $1.50 ±ixed OH per quarter $160,000 ²otal OH recovered per DLH S&A Expenses per quarter $200,800 Mortgage plus interest instalment per quarter $20,000 Annual rate oF interest 6% Mortgage amount $1,109,969 Corporate tax rate 30% ²ax payment each quarter 16500/4 Minimumcash balance 40000 Dividend each quarter 25000 Issue oF 50000 common stock in 3 quarter $400,000 Purchase oF PPE 1 quarter 75000
Background image of page 01

Attachments:

Answers

CourseLover
(12)
Status NEW Posted 19 Dec 2017 07:12 AM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------usi-----------ng -----------our----------- we-----------bsi-----------te -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------ns.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age-----------

Not Rated(0)