Bronco6g Build & Price Planner Spreadsheet

[Badplaid72]

Feel free to use and reorganize the spreadsheet in any way your use to using Excel. I know many Excel experts, especially accountants, expertly use pivot tables, slicers and a multitude of other powerful Excel tools. As and engineer I've always found for my needs simple filters work best for me. I'm use to multiple 1,000 line datasets that I have to merge, combine, and sort to get to an end product that meets my usage needs. Excel is a very powerful tool, but with 475 formula's in its functions library alone and a multitude of other features, it can quickly become intimidating to some, I've always recommended to start simple, if you learn a few formula's and features for your needs, you will do fine.

If in time your needs change and you want to learn more of the advanced functions, there are dozens of great websites and videos to learn from.

Dude, Bro... I’m a decent excel warrior. Like you, it’s about managing a crap ton of data. That was a ton of work. I’m not sure how many realize how sick your list is.

I’m working on a speed rpm spreadsheet right now because none of the pre-regenerated online calculators have the Bronco.And I don’t trust tables or math I can’t see.

if anybody else has done this please post!
North7... thank you!

Sponsored

 

[Svanhildr]

LINK TO DOWNLOAD PLANNER SPREADSHEET:
Bronco6G 2021 Bronco Build & Price Planner - v2a North7 - Chrome_Pony.xlsx

While we are waiting for the official Bronco Build & Price website to go live I created a new Bronco6g forum members Build & Price Planner spreadsheet.

This Excel spreadsheet contains information gathered from other Bronco6g forum threads, it contains both unofficial and official Ford Bronco information. I've merged the Models, Trims, Packages, Options and Pricing together into one spreadsheet that can then be used along with your selections and estimates for package and options pricing. This will allow you to arrive at a target high/low MSRP price for your chosen Bronco.

v2 updates from Chrome_Pony
@Chrome_Pony has done a really nice job taking my original single tab spreadsheet and breaking it out so each Trim has its own tab. Chrome_Pony also then highlighted sections for easier reading. My original v1 tab is still included for when you want to filter on all models at the same time.
Chrome_Pony v2 update post

DISCLAIMER: Due to the inherent nature of leaked information, there will be discrepancies and conflicts between the information in this spreadsheet and officially published Ford information. If this bothers you, please do not use this spreadsheet, for the rest of you, when discrepancies and conflicts do arise, please validate the information against official Ford released information, such as that found on ford.com or the Bronco6g thread that has copies of the officially published Ford Bronco pdf files.
2021 Bronco Prices (2 Door, 4 Door) and Trims Comparison

NEVER USED A SPREADSHEET BEFORE? - Don't worry, you do not need to be an accountant or engineer to use a spreadsheet. A spreadsheet simply contains a collection of information organized in rows and columns. From this information you can "filter" it, meaning to only show the relevant information that is important to you. If you do not have Microsoft Excel on your computer you can upload the file for free to Google Sheets or download the Free LibreOffice, https://www.libreoffice.org/, or get one of the many apps for your Android or iPhone for spreadsheets. Mac users, the Excel file should import just fine for you.

Usage Guidelines:
v1 - Bronco Build & Price Planner - 8/3/2020, @North7
Bronco Build & Price Planner Usage Steps

Overview: This spreadsheet is setup to use filtering, whereby selecting information in each column, from left to right, to filter down to a single model, such as 4 door Badlands. Further, you can then filter to only show one of the Badlands Trim Codes, such as E5C-334A, which includes additional options like the Lux Package.​

Select by column, one at a time:​

Model: Base, Badlands, etc.​

Doors: 2 door, 4 door​

Trim: for example, there are four Badlands 4 door trims​

Available: excluded, allowable, included features for Trim​

Features: Packages, Seats, Tops, etc.​

Description: item, feature, package, etc.​

my Selections: use this column to personalize, for example, put an x in the column to filter on.​

MSPR+DD: This is the MSRP with the Delivery & Destination fee included. The first dollar figure is for the lowest cost Trim for that Model. When you see a dollar figure with a + sign after it, this means the cost of that Model Trim still has to be added, however these costs have not been leaked yet so take your best estimate for your own personal use.​

​

Based on the original work of @72roadster on this thread.​

POSSIBLE Allowable and Excluded Options per Trim Level​

Badlands Planner Example

Summary view of the Bronco Trim Levels
View attachment 23524


Download the spreadsheet by clicking on the attachment below.

This is great, thank you for the time in putting this together!

 

[JonD]

LINK TO DOWNLOAD PLANNER SPREADSHEET:
Bronco6G 2021 Bronco Build & Price Planner - v2a North7 - Chrome_Pony.xlsx

While we are waiting for the official Bronco Build & Price website to go live I created a new Bronco6g forum members Build & Price Planner spreadsheet.

This Excel spreadsheet contains information gathered from other Bronco6g forum threads, it contains both unofficial and official Ford Bronco information. I've merged the Models, Trims, Packages, Options and Pricing together into one spreadsheet that can then be used along with your selections and estimates for package and options pricing. This will allow you to arrive at a target high/low MSRP price for your chosen Bronco.

v2 updates from Chrome_Pony
@Chrome_Pony has done a really nice job taking my original single tab spreadsheet and breaking it out so each Trim has its own tab. Chrome_Pony also then highlighted sections for easier reading. My original v1 tab is still included for when you want to filter on all models at the same time.
Chrome_Pony v2 update post

DISCLAIMER: Due to the inherent nature of leaked information, there will be discrepancies and conflicts between the information in this spreadsheet and officially published Ford information. If this bothers you, please do not use this spreadsheet, for the rest of you, when discrepancies and conflicts do arise, please validate the information against official Ford released information, such as that found on ford.com or the Bronco6g thread that has copies of the officially published Ford Bronco pdf files.
2021 Bronco Prices (2 Door, 4 Door) and Trims Comparison

NEVER USED A SPREADSHEET BEFORE? - Don't worry, you do not need to be an accountant or engineer to use a spreadsheet. A spreadsheet simply contains a collection of information organized in rows and columns. From this information you can "filter" it, meaning to only show the relevant information that is important to you. If you do not have Microsoft Excel on your computer you can upload the file for free to Google Sheets or download the Free LibreOffice, https://www.libreoffice.org/, or get one of the many apps for your Android or iPhone for spreadsheets. Mac users, the Excel file should import just fine for you.

Usage Guidelines:
v1 - Bronco Build & Price Planner - 8/3/2020, @North7
Bronco Build & Price Planner Usage Steps

Overview: This spreadsheet is setup to use filtering, whereby selecting information in each column, from left to right, to filter down to a single model, such as 4 door Badlands. Further, you can then filter to only show one of the Badlands Trim Codes, such as E5C-334A, which includes additional options like the Lux Package.​

Select by column, one at a time:​

Model: Base, Badlands, etc.​

Doors: 2 door, 4 door​

Trim: for example, there are four Badlands 4 door trims​

Available: excluded, allowable, included features for Trim​

Features: Packages, Seats, Tops, etc.​

Description: item, feature, package, etc.​

my Selections: use this column to personalize, for example, put an x in the column to filter on.​

MSPR+DD: This is the MSRP with the Delivery & Destination fee included. The first dollar figure is for the lowest cost Trim for that Model. When you see a dollar figure with a + sign after it, this means the cost of that Model Trim still has to be added, however these costs have not been leaked yet so take your best estimate for your own personal use.​

​

Based on the original work of @72roadster on this thread.​

POSSIBLE Allowable and Excluded Options per Trim Level​

Badlands Planner Example

Summary view of the Bronco Trim Levels
View attachment 23524


Download the spreadsheet by clicking on the attachment below.

This......is.....perfect......thank you!

 

[ronstar]

Thank You north7! This will keep me busy for a while.

 

[BeerForMyHorses]

I think we can approximate a Sasquatch cost, as the Badlands 2DR Mid Package Build is similar to the Wildtrak 2DR Basic (Mid + Sasquatch) , ie, Wildtrak Basic - Badlands Mid = $6780. Subtracting some overlapping options would probably land around $5500ish, in my opinion.

Without even looking at the numbers, just common sense checking that, $5k-$6k for sasquatch makes sense

 

[Rick Astley]

Without even looking at the numbers, just common sense checking that, $5k-$6k for sasquatch makes sense

I actually think it's going to be a $7,000+ option on the Base model. It's a LOT of hardware upgrades over Base. Then scale down in price as the items out of it become standard features further up the line.

 

[BeerForMyHorses]

I actually think it's going to be a $7,000+ option on the Base model. It's a LOT of hardware upgrades over Base. Then scale down in price as the items out of it become standard features further up the line.

True, it's going to be very model-dependant

 

[618TRVLWILD]

Well I get off work at 11pm, and I have a feeling I’m going to be up all night mesmerized by this..?? I also have a feeling this be coming to play as I building my vehicles. Damn why can’t I just be rich!!

 

[618TRVLWILD]

"We're Ford Motor Company..... we make cars , not sense."

Hahaha pretty sure that goes for all automotive manufacturing!

 

[Wyo]

Without even looking at the numbers, just common sense checking that, $5k-$6k for sasquatch makes sense

Maybe I'm reading your response wrong but why would the Sasquatch package be anywhere near that amount on the Badlands. If I look at it right, it is about $6700 difference between the 2 models but the Wildtrak comes with the 2.7L Auto, Sasquatch, Cloth seats, mid package, dual zone climate control plus trail control, trail turn assist and trail one pedal driving. (plus a hard top if comparing 4 door to 4 door).

By the way great song!

 

[dubie7006]

Thanks for this. I think out of all the things that can be optioned (to a Black Diamond, the model I want), those I'm most intrigued by are the tops. "Mesh shade top"? "Bimini top"? "Modular hard top" vs. "MIC hard top"?

GET ME AN OFFICIAL BUILDER, FORD!

And thank you, gents, for putting this together!

 

[BHearn9]

Thanks for this. I think out of all the things that can be optioned (to a Black Diamond, the model I want), those I'm most intrigued by are the tops. "Mesh shade top"? "Bimini top"? "Modular hard top" vs. "MIC hard top"?

GET ME AN OFFICIAL BUILDER, FORD!

And thank you, gents, for putting this together!

I thought I read that the modular hard top wasn’t an option on the BD? Regardless, I still don’t understand the difference between MIC and Modular, other than the color. Perhaps the rear quarter windows being removable? Come on B&P!!!!!

 

[zaki]

Awesome job North7!
The only way this could be even better is if you were from South Texas!

 

[BeerForMyHorses]

Maybe I'm reading your response wrong but why would the Sasquatch package be anywhere near that amount on the Badlands. If I look at it right, it is about $6700 difference between the 2 models but the Wildtrak comes with the 2.7L Auto, Sasquatch, Cloth seats, mid package, dual zone climate control plus trail control, trail turn assist and trail one pedal driving. (plus a hard top if comparing 4 door to 4 door).

By the way great song!

I should've clarified. You bring up good points. I haven't compared those two models side by side (my budget limited me to looking at the black diamond or cheaper haha), but as Rick Astley helped point out it's going to be model dependant. sassy could be around $2k-3k for the Badlands but closer to $6k-$7k for the base model

And by the way... yes it is!

 

[zaki]

sassy could be around $2k-3k ....

"Sassy"!?!?
Man you just destroyed the whole macho thing I had going in my head!!

Sponsored